How to resolve memory issue
2 次查看(过去 30 天)
显示 更早的评论
Hi,
I am working with three .xlsx files. Each xlsx files has sixteen sheets and each sheet has 1600 x 1600 numbers. I need to find maximum value of the three xlsx files comparing sheet wise between three files.. size of each xlsx file is 230,230 KB.
when i do this operation in matlab i get error like following..
Error: 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); Error in main (line 22) data_gabor = data_normalisation((xlsread('C:\Meenu_university\matlab\evidence pooling\New folder\fast\Book_indices',i)),mlc,mas);
Memory information of my system is given below
EDU>> memory Maximum possible array: 2046 MB (2.146e+09 bytes) Memory available for all arrays: 3100 MB (3.251e+09 bytes) * Memory used by MATLAB: 529 MB (5.543e+08 bytes) Physical Memory (RAM): 16307 MB (1.710e+10 bytes) * Limited by contiguous virtual address space available. Limited by virtual address space available.
Hope the available memory is enough the simple task to be completed or I may be wrong also. I need to solve this problem.
Thanks in advance
0 个评论
回答(3 个)
Shaun VanWeelden
2013-1-31
Not to familair with the issue, but my first inclination would be to throw a couple for loops in there and just break it down piece by piece, maybe just 100 columns at a time.
Another idea would be to just save the xlsfile as a text file, which would probably make it a lot easier for MATLAB to read.
Let me know if either of those work for you!
Jason Ross
2013-1-31
When it says "not enough storage", I'd ask you to check the amount of space you have free on your hard drive, too.
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.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!