Error: Not enough storage is available to complete this operation. Any ideas on overcoming this issue

I get this error when reading in data of 352475 x 9 array from excel. Anyone encountered this before and maybe can give any advice?

??? Error: Not enough storage is available to complete this operation.

Error in ==> xlsread at 310 rawData = DataRange.Value;

Error in ==> subSiteData>pushbutton9_Callback at 221 [num, txt, raw] = xlsread(fname);

Error in ==> gui_mainfcn at 96 feval(varargin{:});

Error in ==> subSiteData at 42 gui_mainfcn(gui_State, varargin{:});

Error in ==> @(hObject,eventdata)subSiteData('pushbutton9_Callback',hObject,eventdata,guidata(hObject))

??? Error while evaluating uicontrol Callback

>>

Answer 1

[Jan]

The imported array would need 25'378'200 Bytes, what does not seem to be too large for modern computers. I'd expect the message "Out of memory", when a copy of the array is not possible. So do you find any relevant information in the code, most of all the line 310 of xlsread?

[Al-Mansoor]

Hi Jan & Walter, Yes I have encountered the "out of memory" issue for other routines when attempting to use cell arrays. Strangely, I have run the code this morning and no error has been given on this occasion. Ill keep people posted if I get any developments. Thanks for the replies.

Answer 2

[Walter Roberson]

The file is too big to read into your remaining memory.

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.