Error using xlswrite (line 226)

11 次查看（过去 30 天）
Sifat Ara Senjuti
回答： Myraj 2019-4-24
Hi I wanted to create an excel file by using 'xlswrite', cannot proceed as it is showing some kind of error which says, "Error using xlswrite (line 226) Invoke Error, Dispatch Exception: Source: Microsoft Excel Description: Microsoft Excel cannot access the file 'C:\Program Files\MATLAB\R2017b\bin\AF690720'. 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"
Please help me to find the solution. Thanks.
  2 个评论
Rik
Rik 2018-8-1
It looks like Excel is trying to access a temporary file, but fails. Apart from the suggested solutions, I would suggest opening and closing Excel, making sure the indicated file is deleted, and running Matlab as an administrator.
OCDER
OCDER 2018-8-1
What is the file name? Can you show us the full inputs to your xlswrite?
disp(FileName) % = ?
disp(Data) % = ?
disp(Sheet) % = ?
disp(Range) % = ?
xlswrite(FileName, Data, Sheet, Range)

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Myraj
Myraj 2019-4-24
Hi, if your office not activated must be do that, because I had this kind of problem and I solve it by ativating office. Good luck

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by