Info
This question is closed. Reopen it to edit or answer.
How to get Matlab read my char file in excel?
1 view (last 30 days)
Show older comments
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 Comment
Answers (1)
Alex Mcaulley
on 10 Apr 2019
Is this that you want?
[~,text,~] = xlsread(filename);
text = char(text);
0 Comments
This question is closed.
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!