Error using ==> xlswrite, Could you explain?

13 次查看（过去 30 天）
Kanghyun
Kanghyun 2014-4-24
评论： Image Analyst 2019-1-25
Hello.
I got a following error message that I cannot explain.
??? Error using ==> xlswrite at 213 Invoke Error, Dispatch Exception: Source: Microsoft Excel Description: SaveAs method of Workbook class failed Help File: xlmain11.chm Help Context ID: 0
I was accessing m files from (say) computer A through the network(sharing folders) and was running the matlab on computer B and trying to save the result on computer A.. When I runned the program on computer A itself, there was no problem. On computer B, I am using matlabR2008b and Microsoft Excel 2010. Could anyone explain this? Thanks.

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

回答（2 个）

Image Analyst
Image Analyst 2014-4-24
Are you sure that sharing permissions are set up to allow computer B to write files to computer A? For example, can you transfer a file from B to the same folder on A using Windows Explorer? If you open Excel on B can you save a workbook to that same folder on A directly from Excel (so that MATLAB is not even involved at all)?
Sam Oliver
Sam Oliver 2017-6-29
编辑：Sam Oliver 2017-6-30
I was running into the same issue and fixed it with the following solution. The automatic process that launches MATLAB from computer B calls Excel when using xlswrite. It uses a Windows system user account to launch the process and Excel is looking for the 'Desktop' directory within this system account.
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 个评论
Mohammad
Mohammad 2019-1-24
编辑：Mohammad 2019-1-24
In my case, the path that I was writing the excel file was too long.
Image Analyst
Image Analyst 2019-1-25
In Windows, Excel filenames are only allowed to be up to 218 characters long.

请先登录，再进行评论。

类别

在 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