Thread Subject:

xlswrite

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

"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

"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?

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.

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.

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)?