Some Elaboration on Excel functions (OLE)

[Javier Tovar]

Hola Clip2Mania,

No logro resolver el problema, voy a estudiar un poco de Excel y después te comento.

Saludos

[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.

[endor]

Thank you for sharing.

It is very helpful.

[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

[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

[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.

[Javier Tovar]

We will see tomorrow!

[mol]

I still have no time for anything. Too much work...

[Javier Tovar]

Take your time, here I can wait!

regards

P.D .: Good that have a lot of work!

[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,