Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very Slow creation of Excel Object
Message
From
19/05/1999 03:26:32
 
General information
Forum:
Visual FoxPro
Category:
Object Oriented Programming
Miscellaneous
Thread ID:
00220302
Message ID:
00220308
Views:
25
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
Previous
Reply
Map
View

Click here to load this message in the networking platform