Information générale
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Network:
Windows 2003 Server
>I have a VFP screen into which I want to import a range from an existing XLS sheet
>I imagine having the screen open in VFP. By prssing a button the excel sheet comes to the forground. I highlight a range let's say k144:o162 and by either copying it to the clipbord or executing an excel macro pushing the values of the range into an array and returning it into a VFP array
>
>is this possible?
>
>
>Peter
I'm almost certain it is. A little different from what you describe: Highlight a range, and then push a button on your VFP-form. I assume your Excel-session is in a property of the form:
THISFORM.oExcel
Then check the properties of THISFORM.oExcel.Selection
I don't know how they are named, but you can find out the left-upper-cell and the right-lower as properties of the object THISFORM.oExcel.Selection. After that you just do a FOR-loop in Fox to fill an array.
Sorry I have no prefab code for you, hopes this gives enough direction.
Lennert
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement