loading a large excel file to Matlab

28 views (last 30 days)
Danielle Leblanc
Danielle Leblanc on 22 Jul 2011
Answered: Nick Haddad on 3 Oct 2014
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

Answers (3)

Nick Haddad
Nick Haddad on 3 Oct 2014
This issue is a known bug in MATLAB and has been addressed in the following bug report:
The bug report has a workaround which you can install for MATLAB R2013a through R2014b.

Walter Roberson
Walter Roberson on 22 Jul 2011
Try xlsread() if it is a .xls or .xlsx file; try cvsread() or dlmread() if it is a .csv file.
  1 Comment
Danielle Leblanc
Danielle Leblanc on 22 Jul 2011
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;

Sign in to comment.

Oleg Komarov
Oleg Komarov on 22 Jul 2011
16 400 * 6000 * (8 bytes) = 750.732422 megabytes
If you're in windows import the excel in blocks by specifying the range with xlsread.
  1 Comment
Ipek on 26 Apr 2012
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.

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!