Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combining XLS Sheets
Message
De
26/11/2002 08:22:00
 
 
À
25/11/2002 15:57:44
Todd Wolfe
Certified Marketing Services
Kinderhook, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00726491
Message ID:
00726916
Vues:
17
Several options, each with pros and cons:

1. _VFP.DataToClip(cAlias,nRecordCount,3) && Copy to Clipboard
Open Excel and Paste

This method is very slow on large datasets. Also, fields are not always formatted as you think they would be. Ex: 123-45-6789 (SS#) is Character 9 (stored as 123456789) in VFP, but when it gets to Excel, it is numeric.

2. Copy To cfilename Delimited
Open Excel
Open cfilename (from a text delimited file)

This method is quicker, but more housekeeping since you are writing to temporary txt file.

These are two options off the top of my head.
Let me know if you need the Excel COM code for either method.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform