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.