Page 2 of 3
Re: Some Elaboration on Excel functions (OLE)
Posted: Sun Sep 21, 2014 4:49 pm
by Javier Tovar
Hola Clip2Mania,
No logro resolver el problema, voy a estudiar un poco de Excel y después te comento.
Saludos
Re: Some Elaboration on Excel functions (OLE)
Posted: Mon Sep 22, 2014 2:41 pm
by Agil Abdullah
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.
Re: Some Elaboration on Excel functions (OLE)
Posted: Mon Nov 24, 2014 12:34 pm
by endor
Thank you for sharing.
It is very helpful.
Re: Some Elaboration on Excel functions (OLE)
Posted: Mon Nov 24, 2014 1:12 pm
by radohabjan
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
Re: Some Elaboration on Excel functions (OLE)
Posted: Thu Jan 01, 2015 3:10 pm
by emzampi
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
Re: Some Elaboration on Excel functions (OLE)
Posted: Thu Jan 01, 2015 7:21 pm
by mol
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.
Re: Some Elaboration on Excel functions (OLE)
Posted: Fri Jan 02, 2015 5:50 pm
by Javier Tovar
We will see tomorrow!
Re: Some Elaboration on Excel functions (OLE)
Posted: Fri Jan 02, 2015 8:16 pm
by mol
I still have no time for anything. Too much work...
Re: Some Elaboration on Excel functions (OLE)
Posted: Fri Jan 02, 2015 9:41 pm
by Javier Tovar
Take your time, here I can wait!
regards
P.D .: Good that have a lot of work!
Re: Some Elaboration on Excel functions (OLE)
Posted: Wed Jul 20, 2016 11:02 am
by Tiger
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,