textscan not reading file properly
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Walter Roberson
am 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 ?
Antworten (2)
per isakson
am 2 Jul. 2013
Bearbeitet: per isakson
am 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 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!