xlswrite function

??? 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
The above error message is what im receiving when im trying to use xls write function.
Can anyone help me in solving this

4 Comments

Does it happen even if you try to save something very simple like a scalar value?
Also, does the error occur only when saving to a particular file? For example, try:
xlswrite('test.xlsx', 1)
Ken Atwell
Ken Atwell on 6 Jun 2011
Can you also tell us:
1. Version of MATLAB, and whether its 32-bit or 64-bit
2. Version of Office, and whether (in the case of 2010) its 64-bit
3. Version of Windows (XP, Vista, 7), and whether it is 32-bit or 64-bit
You should put the path where you want to write the Excel file, something like that: xlswrite('C:\Users\KARLI\Desktop\karla.xls', a); Usually Works in Desktop

Sign in to comment.

Answers (2)

Matthew Worker
Matthew Worker on 8 Jun 2011

0 votes

Does the name have a "/" in it or other special chars? I can generate the same error you get if I try that.
vijay sabawat
vijay sabawat on 8 Jun 2011

0 votes

I found the bug..
The bug was in my code i was changing the file path. I mean asking it to save the file in a nonexistent location. Thanks for the answers though.

1 Comment

Noam Handler
Noam Handler on 20 Feb 2024
I had a similar error.
My bug was that the name was too long.

Sign in to comment.

Tags

Asked:

on 6 Jun 2011

Commented:

on 20 Feb 2024

Community Treasure Hunt

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

Start Hunting!