xlsread: Not enough storage is available to complete this operation

7 次查看（过去 30 天）
Peter
Peter 2012-6-28
编辑： 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 个评论
Walter Roberson
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.

请先登录，再进行评论。

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

采纳的回答

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.

更多回答（1 个）

Evan
Evan 2013-3-8
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

类别

在 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