xlswrite and Office 2007
1 view (last 30 days)
Show older comments
I've been using xlswrite to generate Excel sheets from Matlab. Today I upgraded from Office 2003 to Office 2007 and, of course, now my Matlab script won't work.
??? Error using ==> xlswrite at 213 Invoke Error, Dispatch Exception: Source: Microsoft Office Excel Description: Metoden SaveAs for klassen Workbook mislykkedes. Help File: C:\Program Files\Microsoft Office\Office12\1030\XLMAIN11.CHM Help Context ID: 0_ (translation: mislykkedes = failed)
I've located the file, but I can't open it and I don't know what to do with it? If anyone could help me, I'd be very grateful.
Answers (2)
Image Analyst
on 7 Jan 2013
I don't understand why you "upgraded" to an obsolete version. The current version is Excel 2010 for Windows (and I think 2011 for the Mac).
Anyway,...are you sure have the full version, and not some free "Starter edition" that comes free on some new computers (like my home Dell computer). The starter edition does not allow ActiveX communication, like I believe xlswrite() uses.
What extension are you using: .xls or .xlsx?
Can you open any file in Excel, not using MATLAB at all? If you get Excel open, can you save from it?
3 Comments
Image Analyst
on 8 Jan 2013
Does it happen with just that particular file, or you can't open any Excel file at all in MATLAB?
Image Analyst
on 8 Jan 2013
What do you mean that you located the file but can't open it? Did it already exist before you tried to call xlswrite()? Do you mean that, despite the error/warning, xlswrite() created a brand new one (it didn't exist before) anyway?
Are you sure that you just don't have that file already opened up in Excel when you try to write over it?
Ken Atwell
on 8 Jan 2013
This sounds alot like <http://www.mathworks.com/matlabcentral/answers/58171-xlswrite-and-office-2007>. Can you confirm the destination folder exists?
2 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!