Hi Everyone, Could you please help me how to overcome this error? Error: Not enough storage is available to complete this operation. Error in ==> xlsread at 325 rawData = DataRange.Value; Thanks!

How to fix this error "Not enough storage is available to complete ...

Friedrich 2013-4-11

Sounds like an out of memory either on the excel side or in the amount of data which is allowed to be transfered through COM. How big is the excel file you try to read? What is the range you want to read(so A1 to??)?

Ara 2013-4-11

Matlab supposed to plot a map for two stations during five months (5 months per each station). Each day contain an excel file is about 5.85MB, A1-AB1 and each column is about 13354.

Friedrich 2013-4-11

编辑：Friedrich 2013-4-11

在 MATLAB Online 中打开

At least that size works for me. Can you try this:

>> xlswrite('test.xlsx',reshape(1:28*13354,[],28))
>> a = xlsread('test.xlsx');

What extension does your excel file have? What happens when you try to read a smaller range?

Jan 2013-4-11

@Ara: Please post the command, which causes the problem.

Ara 2013-4-11

编辑：Ara 2013-4-11

在 MATLAB Online 中打开

Sorry, if my explanation wasn't clear enough. It means I have to change all of the excel like the code you sent? If yes, I should have said the each excel file is different in terms of size and row but the column are equal(all have 28 column).

@Jan: It seems Matlab could not able to read the other excels anymore. This is that you want me to post??

    Warning: Could not start Excel server for export.
  XLSWRITE will attempt to write file in CSV format.
  > In xlswrite at 166
  ??? Undefined function or variable "ExcelWorkbook".
Error in ==> xlsread at 260
    format = ExcelWorkbook.FileFormat;

the cyclist 2013-4-11

@Ara, I think Friedrich just wants you to try those two lines of code. That code will create an Excel file which is the same size as yours, and then try to read it back again. He wants to see if that works.

Ara 2013-4-11

Thanks to explain me. I tried and those lines gave me an empty excel file but still Matlab can not run to read the rest of the operations and again give me the above error.

Jan 2013-4-11

@Ara: No, I asked for the line of code you use to call XLSWRITE. But the posted error message is revealing, that there is a problem with the Excel server. Which Excel version do you have installed?

Ara 2013-4-11

@Jan: I did not call XLSWRITE in my code and I think this is the main problem that Matlab shows "not enough storage". I guess I have to write a new function and then call the other process, right? Btw, the Excel 2010 I am using.

@ Friedrich: It's ok to process all the data for 4 months but when exactly it start to read files from the fifth month then the error display.

Please let me know your suggestions?

How to fix this error "Not enough storage is available to complete this operation"?

9 个评论
显示 7更早的评论隐藏 7更早的评论

回答（1 个）

2 个评论
显示无隐藏无

类别

标签

Community Treasure Hunt

How to fix this error "Not enough storage is available to complete this operation"?

9 个评论 显示 7更早的评论 隐藏 7更早的评论

回答（1 个）

2 个评论 显示 无 隐藏 无

类别

标签

另请参阅

Community Treasure Hunt

9 个评论
显示 7更早的评论隐藏 7更早的评论

2 个评论
显示无隐藏无