Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

error message: what is going on?

Asked by antonet on 10 May 2013

Dear all,

I use matlab 2011.

I get the following error message

 Error using
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: Microsoft Excel cannot access the file
There are several possible reasons:
 • The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a
currently open workbook.
Help File: xlmain11.chm
Help Context ID: 0
 Error in xlsread (line 248)
ExcelWorkbook = Excel.workbooks.Open(file,0,true);

I am trying to merge 46 excel files. the total size of the merged file is 5 milions rows by 25 columns.

could you tell me what the problem is?



antonet on 10 May 2013

I tried to reboot my pc. When I run the same code I got this new message

 Error: Not enough storage is available to complete this
 Error in xlsread (line 313)
 rawData = DataRange.Value;

I use matlab 2011 64-bit Is there a way to resolve the problem?


Friedrich on 10 May 2013

This is an out of memory error in the excel side. You need to read a smaller range. For your overall purpose I would suggest writing your own code using EXCEL through COM.

antonet on 10 May 2013

Is there any way to "fix" it within Matlab?



No products are associated with this question.

0 Answers

Contact us