Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to left align a column in excel
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Classes - VCX
Divers
Thread ID:
00245967
Message ID:
00246056
Vues:
16
>The way I do it is as follows:
>
> oXL.range("A1:A10").horizontalalignment=(-4131)
>
>I am not sure this is the best way, but if you go into excel and record a macro while you perform the operation, you can use the macro code with a bit of massaging in you VFP code. The only annoyance is EXCEL uses Constants in many cases, but if you step into the macro and go into debug mode, you can hover your mouse over the constants and the contants will reveal their values.
>
>
>>People ,
>>
>>I want to left-align a column in excel.I've tried to left-align the
>>column with horizontal-alignment but it doesn' t work.
>>any suggestions ,
>>
>>regards,
>>David van der vliet.

Also you can include the excel constant file, that can be found here on the UT, in your VFP program. That way you can use the constants just like in VBA. (Must of the time)


HTH
Jeff

It's Time to get a gun.

That's what I've been thinkin.

I think I can afford one, If I do a little less Drinkin.

www.TrueGeeks.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform