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)
Afficher commentaires plus anciens
I have a list of char in my excel file.
![Capture1.PNG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/212953/Capture1.png)
I want to import to my matlab like below:
![Capture2.PNG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/212954/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
Réponses (1)
Alex Mcaulley
le 10 Avr 2019
Is this that you want?
[~,text,~] = xlsread(filename);
text = char(text);
0 commentaires
Cette question est clôturée.
Voir également
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!