loading a large excel file to Matlab

4 次查看（过去 30 天）
Danielle Leblanc
Danielle Leblanc 2011-7-22
回答： Nick Haddad 2014-10-3
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

请先登录，再回答此问题。

回答（3 个）

Nick Haddad
Nick Haddad 2014-10-3
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 2011-7-22
Try xlsread() if it is a .xls or .xlsx file; try cvsread() or dlmread() if it is a .csv file.
  1 个评论
Danielle Leblanc
Danielle Leblanc 2011-7-22
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;

请先登录，再进行评论。

Oleg Komarov
Oleg Komarov 2011-7-22
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 个评论
Ipek
Ipek 2012-4-26
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by