xlswrite and Office 2007

Question

Josefine 2013-1-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/58171-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.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jette 2013-1-8

Which version of MATLAB are you using?

请先登录，再进行评论。

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

Answer 1

Image Analyst 2013-1-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/58171-xlswrite-and-office-2007#answer_70404

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 个评论
显示 1更早的评论隐藏 1更早的评论

Image Analyst 2013-1-8

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

Image Analyst 2013-1-8

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?

请先登录，再进行评论。