Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Export DBF --> XLS
Message
 
À
01/12/2005 05:27:26
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01073597
Message ID:
01073608
Vues:
14
>HI BORISLAV,
>
>I would want to use something like that :
>
>o=CREATEOBJECT("Excel.application")
>.
>.
>
>THANKS

You can but COPY TO is fatser :-)
LOCAL oExcel AS Excel.Application

oExcel = CREATEOBJECT([Excel.Application])
oExcel.Visible = 1
oExcel.WorkBooks.Add()
USE Rab
lnFlds = AFIELDS(laFields)
FOR lnFor = 1 TO lnFlds
    oExcel.Cells(1,lnFor).Value = laFields[lnFor,1]
NEXT
lnRow = 2
SCAN
    FOR lnFor = 1 TO lnFlds
        oExcel.Cells(lnRow,lnFor).Value = TRANSFORM(EVALUATE(laFields[lnFor,1]))
    NEXT
   lnRow = lnRow + 1
ENDSCAN
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform