Excel Automation using OLE

[chkk_26]

I'm trying to open and process data in xlsx format from anothe
application using OLE concept.

Here is my problem.

When I open and try to save data which is more than 65k in an exce
using below code, excel is unable to save more than 65k.

ConnectToNewObject('excel.application')
Application.Workbooks.Add()
|
|
|

But, if I try the below code, I'm able to save more than 65k rows i
excel.

ConnectToNewObject('excel.sheet')
|
|
|

The machine has MS Excel 2007 installed.

Can any one explain this behaviour

 

[Living the Dream]

Hi

Your comment regarding 65k, I assume you mean 65k Rows, if so, this is
because sheets in earlier versions only supported approx 65,500 rows
give or take + / - 100 thereabouts, whereby, later versions, and I can
only gauge on 2010 as it supports up to a 1,048,576 rows.

HTH
Mick.

 

[Living the Dream]

Hi

Your comment regarding 65k, I assume you mean 65k Rows, if so, this is
because sheets in earlier versions only supported approx 65,500 rows
give or take + / - 100 thereabouts, whereby, later versions, and I can
only gauge on 2010 as it supports up to a 1,048,576 rows.

HTH
Mick.

And of course If I wasn't as tired as I was and actually read the post
properly instead of skimming I would have realised what I replied with
has little to do with your question.

On that note, I withdraw my previous response as I have no Idea. :\

Cheers
Mick.

 

[Lynn McGuire]

I'm trying to open and process data in xlsx format from another
application using OLE concept.

Here is my problem.

When I open and try to save data which is more than 65k in an excel
using below code, excel is unable to save more than 65k.

ConnectToNewObject('excel.application')
Application.Workbooks.Add()
|
|
|

But, if I try the below code, I'm able to save more than 65k rows in
excel.

ConnectToNewObject('excel.sheet')
|
|
|

The machine has MS Excel 2007 installed.

Can any one explain this behaviour.

Excel 97 OLE is broken ? Does Excel 2010 have
the same behavior ?

Lynn