Matlab to Excel 2007

Jay — Thu, 01 Nov 2007 15:10:45 -0400

I would like to export a cell array containing more than
256 rows from MATLAB 7.1 to Microsoft Excel 2007. Using
xlswrite I get the following error:

??? Error using ==> xlswrite
Error: Object returned error code: 0x800A03EC

Excel 2007 worksheets can contain more than 256 columns so
the size of the array shouldn’t be a problem. Perhaps the
issue is related to the new *.xlsx extension that Excel
2007 uses or a COM connection not compatible with xlswrite?
That said, I’m fairly new to the MATLAB community and I’m
not sure where to begin to troubleshoot these issues.

Any ideas/solutions would be much appreciated,
Jay

Re: Matlab to Excel 2007

Yair Altman — Thu, 01 Nov 2007 16:29:54 -0400

"Jay " <jay.nospam@mathworks.com> wrote in message
<fgcq9l$rp6$1@fred.mathworks.com>...
> I would like to export a cell array containing more than
> 256 rows from MATLAB 7.1 to Microsoft Excel 2007. Using
> xlswrite I get the following error:
>
> ??? Error using ==> xlswrite
> Error: Object returned error code: 0x800A03EC
>
> Excel 2007 worksheets can contain more than 256 columns so
> the size of the array shouldn’t be a problem. Perhaps the
> issue is related to the new *.xlsx extension that Excel
> 2007 uses or a COM connection not compatible with xlswrite?
> That said, I’m fairly new to the MATLAB community and I’m
> not sure where to begin to troubleshoot these issues.
>
> Any ideas/solutions would be much appreciated,
> Jay

This is an error returned to Matlab from your Excel. Try
using OfficeDoc, which uses a slightly different way to save
Matlab data in Excel:
http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=15192

Yair Altman
http://ymasoftware.com

MATLAB Central Newsreader - Matlab to Excel 2007

Matlab to Excel 2007

Re: Matlab to Excel 2007