Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
EXCEL Automation in VFP
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Divers
Thread ID:
01513555
Message ID:
01513577
Vues:
59
>So, if I need to set the initial and subsequent RANGE() for laying out data, I could do something like initialize a variable for Row and one for Column and use them in the CELLS proeprty instead of an ALPHA Column and Number?

I think so


>Cecil
>
>>>If you want to jump and write your data from a RANGE of ("A3:F3") to ("H3:M3") how would you do this numerically? When you finish your first month in the first range, you then start the 2nd month in the next range of H3:M3, then the 3rd month further to the right likewise.
>>>
>>I have 12 months of data I must show across the spreadsheet from left to right. Since the columns are using alpha characters, is there a way with automation to make the jump using numbers?
>>>
>>>Cecil
>
>>You can address the cells by row and column
>
>>ExcelObject.ActiveWorkBook.Sheets[1].Cells(rownumber, columnnymber).Value = 123
>
>>Gregory
Gregory
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform