필터 지우기
필터 지우기

strings and numbers from excel

조회 수: 10 (최근 30일)
Tomas Iesmantas
Tomas Iesmantas 2011년 5월 24일
Hi, I need to read table from excel. This table are filled with numers and strings and some cells are empty. Is there easy way to read such table in one matrix? Because now matlab just creates to matrices: one with strings and another with numbers and NaN's where strings used to be.
Thanks in advance.

채택된 답변

Fangjun Jiang
Fangjun Jiang 2011년 5월 24일
Use the third returning argument of xlsread()
[NUMERIC,TXT,RAW]=XLSREAD(FILE)
I always prefer this way because then I can process the RAW information as I need. Some helpful functions are, isnan(), isnumeric()

추가 답변 (1개)

the cyclist
the cyclist 2011년 5월 24일
I have used the following entry from the File Exchange with success:

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by