Info

Diese Frage ist geschlossen. Öffnen Sie sie erneut, um sie zu bearbeiten oder zu beantworten.

How to get Matlab read my char file in excel?

1 Ansicht (letzte 30 Tage)
Matlaber
Matlaber am 10 Apr. 2019
Geschlossen: Stephen23 am 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 Kommentar
Cris LaPierre
Cris LaPierre am 10 Apr. 2019
Why are you asking the same question multiple times? Once is sufficient.

Antworten (1)

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

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by