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:15:32
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australie
 
 
À
02/10/2002 22:04:08
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00707180
Message ID:
00707185
Vues:
21
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"
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform