xlswrite and Office 2007

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.

[Jette]

Which version of MATLAB are you using?

Answer 1

[Image Analyst]

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?

[Josefine]

Well, the upgrade was done by the IT-guys on our institution so it was kind of out of my hands. I just needed a newer version of Word and apparently we don't have Office 2010. I'm quite sure I have the full version. I can open all Excel documents, the ones made in the old version too. I can save sheets in the new version. I use the .xlsx for the documents saved in Excel 2007.

[Image Analyst]

Does it happen with just that particular file, or you can't open any Excel file at all in MATLAB?

[Image Analyst]

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?

Answer 2

[Ken Atwell]

This sounds alot like <http://www.mathworks.com/matlabcentral/answers/58171-xlswrite-and-office-2007>. Can you confirm the destination folder exists?

[Image Analyst]

Yeah, I guess it does. By the way, did you get the link right?

[Ken Atwell]

Oops, I meant <http://www.mathworks.com/matlabcentral/answers/8892>