loading a large excel file to Matlab

Hi,

I have an excel file of 16400 columns and 6000 rows. Is it possible to load it to matlab? I am trying to using the import wizard and i am receiving an error: ??? Undefined function or variable "internalSheetNames".

Error in ==> uiimport>filePreview at 285 numberOfSheets=size(internalSheetNames,1);

??? Error while evaluating com.mathworks.mde.dataimport.ImportProxy FilePreviewEventCallback

Answer 1

[Nick Haddad]

This issue is a known bug in MATLAB and has been addressed in the following bug report:

• xlsread might return an error for large spreadsheets

The bug report has a workaround which you can install for MATLAB R2013a through R2014b.

Answer 2

[Walter Roberson]

Try xlsread() if it is a .xls or .xlsx file; try cvsread() or dlmread() if it is a .csv file.

[Danielle Leblanc]

xlsread is not working as well. I am receiving:

??? Error: Not enough storage is available to complete this operation.

Error in ==> xlsread at 316

rawData = DataRange.Value;

Answer 3

[Oleg Komarov]

16 400 * 6000 * (8 bytes) = 750.732422 megabytes

If you're in windows import the excel in blocks by specifying the range with xlsread.

[Ipek]

Thank you so much for your comment, it solved my problem which I've been trying to solve for days... I wish Matlab import wizard could give an error such as "Your data is too big to fit in my memory, I can not import it, try slicing it" rather than just getting stuck in import and make us mad.