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 个）

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