Info

Questa domanda è chiusa. Riaprila per modificarla o per rispondere.

How to get Matlab read my char file in excel?

2 visualizzazioni (ultimi 30 giorni)
Matlaber
Matlaber il 10 Apr 2019
Chiuso: Stephen23 il 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.

Risposte (1)

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

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by