importdata function yields empty data structure

12 次查看（过去 30 天）
Milou
Milou 2012-7-3
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
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
per isakson 2012-7-3
Try
file_spec = '/Users/username/Desktop/fromfile.xlsx';
exist( file_spec, 'file' )
[ num, txt, raw ] = xlsread( file_spec );

更多回答（0 个）

类别

在 Help Center 和 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