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.

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.

On 9/10/2012 1:58 AM, Living the Dream wrote:
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. O.o

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

Cheers
Mick.

On 10/8/2012 6:05 AM, chkk_26 wrote:
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