Some Elaboration on Excel functions (OLE)
Moderator: Rathinagiri
-
- Posts: 1275
- Joined: Tue Sep 03, 2013 4:22 am
- Location: Tecámac, México
Re: Some Elaboration on Excel functions (OLE)
Hola Clip2Mania,
No logro resolver el problema, voy a estudiar un poco de Excel y después te comento.
Saludos
No logro resolver el problema, voy a estudiar un poco de Excel y después te comento.
Saludos
- Agil Abdullah
- Posts: 204
- Joined: Mon Aug 25, 2014 11:57 am
- Location: Jakarta, Indonesia
- Contact:
Re: Some Elaboration on Excel functions (OLE)
Hi Clip2Mania,
your OLE-function worked very well in my laptop (Win-7 with MS-Excel 2007). Thanks very very much.
Salam Hangat from Jakarta.
your OLE-function worked very well in my laptop (Win-7 with MS-Excel 2007). Thanks very very much.
Salam Hangat from Jakarta.
Agil Abdullah Albatati (just call me Agil)
Programmer Never Surrender
Programmer Never Surrender
Re: Some Elaboration on Excel functions (OLE)
Thank you for sharing.
It is very helpful.
It is very helpful.
-----------
Rey
Rey
-
- Posts: 99
- Joined: Mon Nov 30, 2009 7:17 am
- Location: Slovenia
- Contact:
Re: Some Elaboration on Excel functions (OLE)
Hello friends,
You get error in case your Excell Sheet 2 don't have name "Sheet 2" ( this is normal when you don't have english Excel version):
Line 84: oExcel:WorkSheets("Sheet 2"):Cells(1,1):Value:="Text in sheet 2"
br Rado
You get error in case your Excell Sheet 2 don't have name "Sheet 2" ( this is normal when you don't have english Excel version):
Line 84: oExcel:WorkSheets("Sheet 2"):Cells(1,1):Value:="Text in sheet 2"
br Rado
Re: Some Elaboration on Excel functions (OLE)
for Javier Tovar
I had your same mistake and I modified these two lines now works
modifed for italian
riga 54=oSheet:Cells(row,1):Formula:="=somma(A"+alltrim(str(frow,5,0))+":A"+alltrim(str(row-1,5,0))+")"
riga 84= oExcel:WorkSheets("foglio2"):Cells(1,1):Value:="Text 2" // Write something directly in Sheet 2
saluti e buon anno
I had your same mistake and I modified these two lines now works
modifed for italian
riga 54=oSheet:Cells(row,1):Formula:="=somma(A"+alltrim(str(frow,5,0))+":A"+alltrim(str(row-1,5,0))+")"
riga 84= oExcel:WorkSheets("foglio2"):Cells(1,1):Value:="Text 2" // Write something directly in Sheet 2
saluti e buon anno
Re: Some Elaboration on Excel functions (OLE)
So, maybe we can put summary for all fuctions we can do/we know.. working with excel and libre/open office?
I've realized app which reads some things from sheets, I've learned some new things, I'll describe it tomorrow.
I've realized app which reads some things from sheets, I've learned some new things, I'll describe it tomorrow.
-
- Posts: 1275
- Joined: Tue Sep 03, 2013 4:22 am
- Location: Tecámac, México
Re: Some Elaboration on Excel functions (OLE)
We will see tomorrow!
Re: Some Elaboration on Excel functions (OLE)
I still have no time for anything. Too much work...
-
- Posts: 1275
- Joined: Tue Sep 03, 2013 4:22 am
- Location: Tecámac, México
Re: Some Elaboration on Excel functions (OLE)
Take your time, here I can wait!
regards
P.D .: Good that have a lot of work!
regards
P.D .: Good that have a lot of work!
Re: Some Elaboration on Excel functions (OLE)
Hi,
Do anyone know how to change the font type and size from same line of a cell? For example, I would like to change the string " From Buyer" to "From" ==> Font:Bold := .T. and Font:Size := 10 and "Buyer" ==> Font:Italic := .T.and Font:Size := 14. Thanks.
Regards,
Do anyone know how to change the font type and size from same line of a cell? For example, I would like to change the string " From Buyer" to "From" ==> Font:Bold := .T. and Font:Size := 10 and "Buyer" ==> Font:Italic := .T.and Font:Size := 14. Thanks.
Regards,