Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Putting values in more than one excel-cell at a time
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01301740
Message ID:
01301743
Vues:
7
>Hello,
>
>I try to create a general class that must read Excel-Data into a VFP-Cursor and vice versa.
>
>It is no problem to do it on a cell-basis, but it is too slow, especially when putting the values into the sheet.
>
>Is there any way to select a range in Excel and fill all the cells with the values in one step? E.g. to select a whole column as range and put the values from an array one in each cell?
>
>Thanks
>Alexander

Sure:
Dimension Array2Excel(i,j)
* populate array as needed, make sure that its dimensions are the same as
 *the range you need to fill in

.....
oExcel.Range(...).Value = ArrayPasser("Array2Excel") 
.....
*--------------------------------------------
Procedure ArrayPasser 
Lparameters lcArrayName 
Return @&lcArrayName    && for VFP7 and above
Good Luck
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform