Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
xlswrite

Subject: xlswrite

From: Ozge Taskan

Date: 31 May, 2010 17:18:05

Message: 1 of 6

Hi,

I have a matrix that has size of (532,1024). I try to use xlswrite. However I get
"Error: Object returned error code: 0x800A03EC" message. I know that there is no limit like 1000 in excel. What should I do to solve this problem?

Thank you very much in advance.

Ozge

Subject: xlswrite

From: us

Date: 31 May, 2010 17:39:05

Message: 2 of 6

"Ozge Taskan" <lordgy@yahoo.com> wrote in message <hu0r0c$o66$1@fred.mathworks.com>...
> Hi,
>
> I have a matrix that has size of (532,1024). I try to use xlswrite. However I get
> "Error: Object returned error code: 0x800A03EC" message. I know that there is no limit like 1000 in excel. What should I do to solve this problem?
>
> Thank you very much in advance.
>
> Ozge

a hint:

http://www.mathworks.com/support/solutions/en/data/1-3Y9HJ2/index.html?solution=1-3Y9HJ2

us

Subject: xlswrite

From: Ozge Taskan

Date: 1 Jun, 2010 15:41:05

Message: 3 of 6

"us " <us@neurol.unizh.ch> wrote in message <hu0s7p$d9i$1@fred.mathworks.com>...
> "Ozge Taskan" <lordgy@yahoo.com> wrote in message <hu0r0c$o66$1@fred.mathworks.com>...
> > Hi,
> >
> > I have a matrix that has size of (532,1024). I try to use xlswrite. However I get
> > "Error: Object returned error code: 0x800A03EC" message. I know that there is no limit like 1000 in excel. What should I do to solve this problem?
> >
> > Thank you very much in advance.
> >
> > Ozge
>
> a hint:
>
> http://www.mathworks.com/support/solutions/en/data/1-3Y9HJ2/index.html?solution=1-3Y9HJ2
>
> us

Sorry, this page is not clear for me. I guess if i can save my documents in excel 2007, I can use more columns. Matlab uses 2007 but it saves as 2003. Sorry may be this is very easy question but can it be possible to save as .xlsx to increase the number of columns used?

Subject: xlswrite

From: ImageAnalyst

Date: 1 Jun, 2010 15:51:38

Message: 4 of 6

If you have Excel 2007 installed and it's saving it as Excel 2003
format, then check your extension for your filename. If it's xls it
may use 2003 but if it's xlsx then it may use 2007. 2007 may allow
1024 columns but I know Excel 2003 only allows 256 columns.

Subject: xlswrite

From: Ozge Taskan

Date: 2 Jun, 2010 09:26:07

Message: 5 of 6

ImageAnalyst <imageanalyst@mailinator.com> wrote in message <695e3b1b-1f52-42c2-bac5-3fbe69b75090@40g2000vbr.googlegroups.com>...
> If you have Excel 2007 installed and it's saving it as Excel 2003
> format, then check your extension for your filename. If it's xls it
> may use 2003 but if it's xlsx then it may use 2007. 2007 may allow
> 1024 columns but I know Excel 2003 only allows 256 columns.

Firstly thank you very much for your answer. My code was
 >>xlswrite('A',cons_new, 1)
 then I changed it as
 >>xlswrite('A.xlsx',cons_new, 1)
however I get an answer as
??? Undefined variable "ExcelWorkbook" or class "ExcelWorkbook.Close".

What does it mean?

Thank you in advance.

Subject: xlswrite

From: ImageAnalyst

Date: 2 Jun, 2010 11:26:09

Message: 6 of 6

Looks like you maybe don't have Excel 2007 installed. Can you start
it yourself with the ActiveX commands (search the help or website for
instructions on that)?

Tags for this Thread

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.

Contact us