Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rows in Excel2000 limited to 65000 with automation
Message
From
02/10/2002 22:15:32
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
 
 
To
02/10/2002 22:04:08
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00707180
Message ID:
00707185
Views:
20
Hi Claudio,

I just realised that I'd been issuing:
oWorkSheet.Cells[nRows,1] = "Hi There"
instead of
oWorkSheet.Cells[nRows,1].Value = "Hi There"
Thanks,
Gavin...

>Hi, Gavin.
>
>>This means that with automation you are limited to 65,000 rows ( I think <g> ).
>
>This code works for me:
>
>
>Local oWorksheet as "excel.application"
>oWorkSheet = CreateObject("excel.application")
>oWorkSheet.Visible=.t.
>oworkSheet.Workbooks.Add()
>oworksheet.Cells[65001,1].Value = "Hi There"
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform