error message: what is going on?
显示 更早的评论
Dear all,
I use matlab 2011.
I get the following error message
Error using
Interface.000208DB_0000_0000_C000_000000000046/Open
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: Microsoft Excel cannot access the file
'C:\wow2\oio.xlsx'.
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?
thanks
6 个评论
per isakson
2013-5-10
编辑：per isakson
2013-5-10
The error message includes three possible reasons. Why is it not one of these? Did you try to use a different name like, test17.xlsx?
antonet
2013-5-10
Friedrich
2013-5-10
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.
vcmorini
2017-1-31
News on this post? Having the same issue here!
John D'Errico
2017-1-31
编辑：John D'Errico
2017-1-31
IF the error is coming from Excel, not from MATLAB, then you cannot fix it in MATLAB. You need to be looking at Excel for this.
回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
2017-1-31
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
