importdata function yields empty data structure
显示 更早的评论
Hello,
I have been importing .xls and .xlsx data into matlab with calls similar to the following:
rawdata = importdata('/Users/username/Desktop/fromfile.xlsx');
it has worked in the past, but now MATLAB creates empty data structures.
i can open the .xlsx file in openoffice to see that the file is not empty, as well as in SPSS from which it was originally saved from a .sav to .xlsx.
any ideas as to why this function does not retrieve my data?
Thanks in advance for all your help.
1 个评论
Walter Roberson
2012-7-3
Does the file have text in the each row? .xlsx and .xls files are read by calling xlsread() , and
The array does not contain any information from header lines, or from outer rows or columns that contain nonnumeric data. xlsread converts text in inner rows and columns to NaN.
采纳的回答
per isakson
2012-7-3
Try
file_spec = '/Users/username/Desktop/fromfile.xlsx';
exist( file_spec, 'file' )
[ num, txt, raw ] = xlsread( file_spec );
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Workspace Variables and MAT Files 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
