Hi,could you help me please ,I'm trying to load a big data set to matlab work and I have an error below,what can I do for this?

Error using xlsread (line 247) Invoke Error, Dispatch Exception: Not enough storage is available to complete this operation.

Error in testdata (line 3) m = xlsread('DataBase.xlsx');

Answer 1

[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.

Answer 2

[Walter Roberson]

Do not read the entire file at the same time. Or make your program more efficient so the rest of the program uses less memory leaving more memory free for the data. Or get more RAM. Or increase your virtual memory (which will slow down the program greatly but it will at least run.) You might need to switch to a 64 bit operating system running a 64 bit version of MATLAB.

Answer 3

[Debejyo Chakraborty]

I am using 2014a with the same error. The excel sheet is about 5MB, not that big in my opinion.

[Walter Roberson]

R2014a would be covered by the bug report listed above by Nick.