xlswrite command not working

Question

Atinesh Singh 2017-7-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/349239-xlswrite-command-not-working

回答： Håkon Bye 2019-8-13

I am trying to export matlab data to excel file but I am getting this error

Error using xlswrite (line 219)
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: The file could not be accessed.

Command I am using

xlswrite('file.xslx', [1 2 3]);

I tried reinstalling office, but It didn't work. I am using Windows 10 Pro (x64), Office 2016 (x64).

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Fangjun Jiang 2017-7-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/349239-xlswrite-command-not-working#answer_274599

编辑：Fangjun Jiang 2017-7-18

should it be xlswrite('file. xlsx', [1 2 3])?

Sometimes when you initially had some types of file error, the file kept being open so xlswrite() can not over-write it. That is the cause for your error message.

Just delete that file completely and re-try.

2 个评论
显示无隐藏无

Atinesh Singh 2017-7-18

That's minor typo, But same error persists even with extension 'xlsx'.

Fangjun Jiang 2017-7-19

在 MATLAB Online 中打开

Try a different file name, for example, run this separately in Command Window and see what happens:

xlswrite('test.xlsx', [1 2 3])

请先登录，再进行评论。

Answer 2

Jan 2017-7-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/349239-xlswrite-command-not-working#answer_274616

在 MATLAB Online 中打开

The error message contains 4 ideas. Did you try them? If so, mentioning this detail would be very useful for the readers.

As Fangjun Jiang has pointed out already: ".xslx" might not be the wanted file extension. If the file is opened by another process or the folder is write protected, such an error message would be expected also.

Some strange Excel problem have been solved by this tip:

For x64 processes create the following folder:

C:\Windows\SysWOW64\config\systemprofile\Desktop

For x86 processes create the following folder:

C:\Windows\System32\config\systemprofile\Desktop

2 个评论
显示无隐藏无

Atinesh Singh 2017-7-18

That's minor typo, But same error persists even with extension 'xlsx'.

Atinesh Singh 2017-7-18

The folder you mentioned is already present.

请先登录，再进行评论。

Answer 3

Håkon Bye 2019-8-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/349239-xlswrite-command-not-working#answer_387326

I had a similar error message. It turned out that the error occured because I had my MATLAB folder stored at a onedrive folder. I think the problem is caused by the spaces in the name of the onedrive folder.