Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

How to get Matlab read my char file in excel?

1 vue (au cours des 30 derniers jours)
Matlaber
Matlaber le 10 Avr 2019
Clôturé : Stephen23 le 10 Avr 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 commentaire
Cris LaPierre
Cris LaPierre le 10 Avr 2019
Why are you asking the same question multiple times? Once is sufficient.

Réponses (1)

Alex Mcaulley
Alex Mcaulley le 10 Avr 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