Read xlsx file to matlab

  • Follow


Hello 

I was trying to import a xlsx file to matlab but did not have luck.

My data is like 

-80.669210	28.141130
-81.772990	29.185000
-82.286840	29.684610
-82.163400	29.222970
-81.357740	30.161860

which are 54 rows.

I tried [num,txt,raw]=xlsread('try.xlsx') and got 'File contains unexpected record length.  Try saving as Excel 98'.

I tried importdata try.xlsx and got a warning: File contains uninterpretable data.

I works after I convert it to xls. But I can not do that because I have other files which has more rows than what xls can fit.

Thanks
Eric
0
Reply Eric 12/2/2009 9:07:02 PM

"Eric " <tanzhao.eric@gmail.com> wrote in message <hf6ktm$23p$1@fred.mathworks.com>...
> Hello 
> 
> I was trying to import a xlsx file to matlab but did not have luck.
> 
> My data is like 
> 
> -80.669210	28.141130
> -81.772990	29.185000
> -82.286840	29.684610
> -82.163400	29.222970
> -81.357740	30.161860
> 
> which are 54 rows.
> 
> I tried [num,txt,raw]=xlsread('try.xlsx') and got 'File contains unexpected record length.  Try saving as Excel 98'.
> 
> I tried importdata try.xlsx and got a warning: File contains uninterpretable data.
> 
> I works after I convert it to xls. But I can not do that because I have other files which has more rows than what xls can fit.
> 
> Thanks
> Eric

Excel 2007 has a problem with MATLAB or vice versa. Try saving it as a text file, then import.
0
Reply ade77 12/3/2009 3:05:21 AM


1 Replies
1347 Views

(page loaded in 0.038 seconds)

Similiar Articles:













7/22/2012 2:12:48 AM


Reply: