Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I center a cell in Excel 97
Message
 
À
15/04/1998 01:29:41
Fernando España
Alta Tecnologia En Informatica
Guatemala, Guatemala
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00092033
Message ID:
00092103
Vues:
21
Try this. Fox does not support the word argument so you must find the Number value. Some times easy, some time not.

Fexcel.cells[3,3].HorizontalAlignment =7
or
Fexcel.range("B3").horizontalalign=7

HTH
Jeff

>I have an application in vfp, and I'm using excel for make some reports, my reports need use excel functions, and i have not problem with this, but i can not center an cell in the worksheet with the command
>Fexcel.range("B3").horizontalalign="xlcenter"
>this give me a error
>i tray to do this
>Fexcel.cells(3,2).horizontalalign="xlcenter"
> and i can not center my information
>
>how can i do this?
> sorry for my English
>
>Spanish version:
>
>Tengo una aplicacion, que necesita realizar calculos en excel, y luego enviar a imprimir esta informacion, estoy usando el print y el preview de excel porque siento que funcionan mejor que los de VFP, sin embargo, no logro centrar una celda determinada en en mi hoja de excel porque obtengo un error, yo uso los comandos siguientes:
>
>Fexcel.range("B3").horizontalalign="xlcenter"
>este comando y el siguiente me dan error
>Fexcel.cells(3,2).horizontalalign="xlcenter"
>
>que puedo hacer?

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