Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Very Slow creation of Excel Object
Message
De
19/05/1999 03:26:32
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Programmation Orientée Object
Divers
Thread ID:
00220302
Message ID:
00220308
Vues:
26
Russell,

You may want to try to save you table in Excel format by using
COPY to your_excel_file type xl5
and then let your oExcel to open your_excel_file

You may also want to investigate the _vfp.dataToClip() method


>I have been trying to send data to an Excel Object as follows and it takes about 2 minutes per 100 records. Is there anything I can do to speed it up
>
>n= 0
>SCAN
> n = n+1
> oExcel.Cells(1,n) = FirstName
> oExcel.Cells(2,n) = LastName
> oExcel.Cells(3,n) = Address1
> oExcel.Cells(4,n) = Address2
>ENDSCAn
Chen Nan
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform