How to resolve memory issue

Question

Meenu 2013-1-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/60722-how-to-resolve-memory-issue

回答： Nick Haddad 2014-10-3

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Shaun VanWeelden 2013-1-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/60722-how-to-resolve-memory-issue#answer_73093

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!

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

Meenu 2013-1-31

Hi, Thanks a lot.

I solved the issue.. Itseems like Matlab allocates memory dynamically for the entire excel file and try to find out the rows and columns which has values. so i have modified the code by mentioning the ranges of rows and columns while reading those xlsx files. Now i could run the code.

请先登录，再进行评论。