Info

이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.

How to get Matlab read my char file in excel?

조회 수: 1 (최근 30일)
Matlaber
Matlaber 2019년 4월 10일
마감: Stephen23 2019년 4월 10일
I have a list of char in my excel file.
Capture1.PNG
I want to import to my matlab like below:
Capture2.PNG
I had tried below
y=csvread('test10042019.csv');
x=dlmread('test10042019_char.csv');
But is not working
>> x=dlmread('test10042019_char.csv',' ', 1,0);
Error using dlmread (line 143)
Mismatch between file and format string.
Trouble reading 'Numeric' field from file (row number 1, field
number 1) ==> ,\n
THank you.
  댓글 수: 1
Cris LaPierre
Cris LaPierre 2019년 4월 10일
Why are you asking the same question multiple times? Once is sufficient.

답변 (1개)

Alex Mcaulley
Alex Mcaulley 2019년 4월 10일
Is this that you want?
[~,text,~] = xlsread(filename);
text = char(text);

태그

Community Treasure Hunt

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

Start Hunting!

Translated by