xlsread: Not enough storage is available to complete this operation

Question

Peter 2012-6-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42239-xlsread-not-enough-storage-is-available-to-complete-this-operation

编辑： Walter Roberson 2016-6-29

Hi all

I am attempting to import a spreadsheet into MATLAB which is apporximately 200MB in size. When I use xlsread I get the following message:

Invoke Error, Dispatch Exception: Not enough storage is available to complete this operation.

Error in xlsreadCOM (line 64)
    rawData = DataRange.Value;
Error in xlsread (line 230)
        [numericData, textData, rawData, customOutput] = xlsreadCOM(file, sheet, range, Excel,
        customFun);

Is this a limitation on the size of file which MATLAB can read or is it a hardware limitation?

Thanks

Peter

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Walter Roberson 2012-6-28

Sounds like you just don't have enough free memory. Make sure you have cleared variables you do not need anymore.

请先登录，再进行评论。

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

Answer 1

Nick Haddad 2014-10-3

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42239-xlsread-not-enough-storage-is-available-to-complete-this-operation#answer_153782

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.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Kyle O'Donnell 2016-6-29

Are there fixes for earlier versions of matlab? I run 2012b.

请先登录，再进行评论。

Answer 2

Evan 2013-3-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42239-xlsread-not-enough-storage-is-available-to-complete-this-operation#answer_77914

I don't know whether my experience can help or not, but I was having that problem one day. I have just 2710 rows of data but still get that error. I was thinking maybe xlsread thinks some of my cells below Row 2710 (till 100k rows which are blank) and continues reading until the end of excel. So I delete all of the rows below and problem solved