Error using ==> xlswrite, Could you explain?
2 views (last 30 days)
Show older comments
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.
0 Comments
Answers (2)
Image Analyst
on 24 Apr 2014
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)?
0 Comments
Sam Oliver
on 29 Jun 2017
Edited: Sam Oliver
on 30 Jun 2017
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 Comments
Image Analyst
on 25 Jan 2019
In Windows, Excel filenames are only allowed to be up to 218 characters long.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!