textscan not reading file properly
1 view (last 30 days)
Show older comments
I have used textscan successfully in this manner for other files (different file extension). I am not sure why it does not work for this excel sheet (.xlsx). It is telling me that M = [0x1 double] [0x1 double].
clear
fid=fopen('data.xlsx');
M = textscan(fid,'%n%n')
fclose(fid);
Any help is appreciated. Thanks!
2 Comments
Walter Roberson
on 2 Jul 2013
Which MATLAB release are you using, and which operating system? If you are on MS Windows, which version of Excel do you have installed ?
Answers (2)
per isakson
on 2 Jul 2013
Edited: per isakson
on 2 Jul 2013
Could it be that the cells in Excel are defined as right-justified text? Try
[num,txt,raw] = xlsread('data.xlsx')
and inspect all three outputs.
Which versions of Excel and Matlab do you use?
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!