xlsread: Not enough storage is available to complete this operation
4 次查看(过去 30 天)
显示 更早的评论
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
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
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 个评论
更多回答(1 个)
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
0 个评论
另请参阅
类别
在 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!