MATLAB Answers


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?



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?


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.

on 10 May 2013

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


No products are associated with this question.

0 Answers

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply today