Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 to Excel
Message
From
12/07/2000 22:49:12
Jonathan Cochran
Alion Science and Technology
Maryland, United States
 
 
To
12/07/2000 18:59:56
Todd Cottengim
Alpine Land Information Services
Redding, California, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00391588
Message ID:
00391623
Views:
10
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
Previous
Reply
Map
View

Click here to load this message in the networking platform