I have an excel-file which consists of about roughly 10,000 rows and has a size of around 800KB
When I try to import the data to MATLAB both with GUI import tool, or using XLSREAD I get the following message:
Could not open the spreadsheet. MATLAB reported the following error:
XLSREAD unable to read sheet "Sheet1"
File contains unexpected record length. Try saving as Excel 98
I tried saving as excel 98, but didn't help?...funny thing is, I can import other excel-files which are bigger than 10,000 rows and 800KB in size?!...
Ideas? =) My excel-file shouldn't consist anything special, just columns of numeric data with headers consisting of text...
NOTE:
It seems this only comes when I use MATLAB in Ubuntu 12.10...When I tried it in Windows XP it works just fine....??
UPDATE:
XLSREAD in UBUNTU just doesn't seem to like big excel files...If I reduce the number of rows...voila...=(
UPDATE2:
The limit value of rows seems to be 746 rows. If I have 746 rows in file, reading is okay, if I have > 746, no game...
copy
andpaste values
into a new excel file.