Info

La pregunta está cerrada. Vuélvala a abrir para editarla o responderla.

How to get Matlab read my char file in excel?

1 visualización (últimos 30 días)
Matlaber
Matlaber el 10 de Abr. de 2019
Cerrada: Stephen23 el 10 de Abr. de 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 comentario
Cris LaPierre
Cris LaPierre el 10 de Abr. de 2019
Why are you asking the same question multiple times? Once is sufficient.

Respuestas (1)

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

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by