textscan not reading file properly
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Walter Roberson
le 2 Juil 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 ?
Réponses (2)
per isakson
le 2 Juil 2013
Modifié(e) : per isakson
le 2 Juil 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 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!