Info

This question is closed. Reopen it to edit or answer.

How to get Matlab read my char file in excel?

1 view (last 30 days)
Matlaber
Matlaber on 10 Apr 2019
Closed: Stephen23 on 10 Apr 2019
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 Comment
Cris LaPierre
Cris LaPierre on 10 Apr 2019
Why are you asking the same question multiple times? Once is sufficient.

Answers (1)

Alex Mcaulley
Alex Mcaulley on 10 Apr 2019
Is this that you want?
[~,text,~] = xlsread(filename);
text = char(text);

This question is closed.

Tags

Community Treasure Hunt

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

Start Hunting!