Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP6 to Excel
Message
De
12/07/2000 22:49:12
Jonathan Cochran
Alion Science and Technology
Maryland, États-Unis
 
 
À
12/07/2000 18:59:56
Todd Cottengim
Alpine Land Information Services
Redding, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Divers
Thread ID:
00391588
Message ID:
00391623
Vues:
11
Put your data into a table or cursor, make sure the table is selected,
then try this. I don't know if it will be faster or not, but you
can give it a try.
LOCAL lo_Excel


_VFP.DATATOCLIP( , , 3 )

lo_Excel = CREATEOBJECT("Excel.Application")

lo_Excel.Workbooks.ADD()

lo_Excel.ActiveSheet.Paste()

lo_Excel.VISIBLE = .T.

lo_Excel.QUIT()
lo_Excel = .NULL.
RELEASE lo_Excel
>We are starting to directly write file to Excel using a variety of VBA commands that also work in VFP. Unfortunatly, The only way we have found to change the value of a cell is by Value property of a cell. This is ok if the data we are trying ot send to Excel is a small range but when there are 40 columns and 200 rows of data, changing the value of 8000 cells can take some time. Is there a way to "drop" an array into a range of cells instead of chaning the values one by one?
>
>My programming partner and myself are a couple of self-taught programmers and appreciate any help offered.
>
>Todd Cottengim
>Alpine Land Information Services
>tcottengim@alpine-lis.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform