xlsread: Not enough storage is available to complete this operation

Hi all

I am attempting to import a spreadsheet into MATLAB which is apporximately 200MB in size. When I use xlsread I get the following message:

Invoke Error, Dispatch Exception: 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);

Is this a limitation on the size of file which MATLAB can read or is it a hardware limitation?

Thanks

Peter

[Walter Roberson]

Sounds like you just don't have enough free memory. Make sure you have cleared variables you do not need anymore.

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.

[Kyle O'Donnell]

Are there fixes for earlier versions of matlab? I run 2012b.

Answer 2

[Evan]

I don't know whether my experience can help or not, but I was having that problem one day. I have just 2710 rows of data but still get that error. I was thinking maybe xlsread thinks some of my cells below Row 2710 (till 100k rows which are blank) and continues reading until the end of excel. So I delete all of the rows below and problem solved