Puedes obtener los nombres de la siguiente forma:
oExcel:sheets( n ):Name
donde n debe ser un número desde 1 hasta la cantidad de hojas del libro
para conocer la cantidad de hojas del libro.
oExcel:sheets:count()
espero les sea de ayuda.
saludos cordiales,
Luis Vasquez
Some Elaboration on Excel functions (OLE)
Moderator: Rathinagiri
- luisvasquezcl
- Posts: 1258
- Joined: Thu Jul 31, 2008 3:23 am
- Location: Chile
- Contact:
Re: Some Elaboration on Excel functions (OLE)
luisvasquezcl wrote:Puedes obtener los nombres de la siguiente forma:
oExcel:sheets( n ):Name
donde n debe ser un número desde 1 hasta la cantidad de hojas del libro
para conocer la cantidad de hojas del libro.
oExcel:sheets:count()
espero les sea de ayuda.
saludos cordiales,
Luis Vasquez
Hi Luis,
Sorry, I don't point out my question clearly. My question is as the picture below to set different font type and size in the excel "cell:B2". After several tried out, I found the solution to use the code like this ...
oSheet:Cells( alltrim(str(I+17)) , 6 ): Characters(Start:=1, Length:=34):Font:Size := 8
oSheet:Cells( alltrim(str(I+17)), 1 ): Characters(Start:=1, Length:=18):Font:Bold := .T.
Many thanks for your help.
- Attachments
-
- excel_test.jpg (28.24 KiB) Viewed 3843 times
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Some Elaboration on Excel functions (OLE)
Cool!
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- serge_girard
- Posts: 3165
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: Some Elaboration on Excel functions (OLE)
Yes, nice XLS tip !
Serge
Serge
There's nothing you can do that can't be done...