MATLAB Central > MATLAB Newsreader > Matlab to Excel 2007

Thread Subject: Matlab to Excel 2007

Subject: Matlab to Excel 2007

From: Jay

Date: 1 Nov, 2007 15:10:45

Message: 1 of 2

Reply to this message

Add author to My Watch List

View original format

Flag as spam

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

Subject: Matlab to Excel 2007

From: Yair Altman

Date: 1 Nov, 2007 16:29:54

Message: 2 of 2

Reply to this message

Add author to My Watch List

View original format

Flag as spam

"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

Tags for this Thread

Everyone's Tags:

xlswrite, excel

Add a New Tag:

Separated by commas
Ex.: root locus, bode

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Tag Activity for This Thread
Tag	Applied By	Date/Time
excel	Jay	1 Nov, 2007 11:15:05
xlswrite	Jay	1 Nov, 2007 11:15:05

Feed for this Thread

E-mail this page to a colleague

Public Submission Policy
NOTICE: Any content you submit to MATLAB Central, including personal information, is not subject to the protections which may be afforded information collected under other sections of The MathWorks, Inc. Web site. You are entirely responsible for all content that you upload, post, e-mail, transmit or otherwise make available via MATLAB Central. The MathWorks does not control the content posted by visitors to MATLAB Central and, does not guarantee the accuracy, integrity, or quality of such content. Under no circumstances will The MathWorks be liable in any way for any content not authored by The MathWorks, or any loss or damage of any kind incurred as a result of the use of any content posted, e-mailed, transmitted or otherwise made available via MATLAB Central. Read the complete Disclaimer prior to use.