Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rows in Excel2000 limited to 65000 with automation
Message
De
02/10/2002 22:04:08
 
 
À
02/10/2002 21:49:50
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australie
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00707180
Message ID:
00707184
Vues:
22
This message has been marked as the solution to the initial question of the thread.
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"
Claudio Lassala
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform