Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I center a cell in Excel 97
Message
 
To
15/04/1998 01:29:41
Fernando España
Alta Tecnologia En Informatica
Guatemala, Guatemala
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00092033
Message ID:
00092103
Views:
19
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
Previous
Reply
Map
View

Click here to load this message in the networking platform