How to resolve memory issue

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

Answer 1

[Shaun VanWeelden]

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!

[Meenu]

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.

Answer 2

[Jason Ross]

When it says "not enough storage", I'd ask you to check the amount of space you have free on your hard drive, too.

[Meenu]

Thanks friend. Solved the problem.

Answer 3

[Nick Haddad]

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.