Open.office read only

HMG Samples and Enhancements

Moderator: Rathinagiri

Post Reply
User avatar
nekbmm
Posts: 41
Joined: Sat Jul 16, 2016 3:16 am
DBs Used: DBF,SQLite
Location: Ivanjica, Serbia
Has thanked: 2 times

Open.office read only

Post by nekbmm » Fri Feb 23, 2018 7:41 am

How to open an excel file to not be raedonly the data input attributes ?


IF ( oServiceManager := win_oleCreateObject( "com.sun.star.ServiceManager" ) ) != NIL
oDesktop := oServiceManager:createInstance( "com.sun.star.frame.Desktop" )
oBook := oDesktop:loadComponentFromURL( "file:///"+cDir+"\Poreska_prijava_pdv.xls", "_blank",0, {} )
oSheet := oBook:getSheets():getByIndex(0)


oSheet:getCellRangeByName( "B10" ):SetString('U PERIODU OD: '+ Dtoc(Datup1) + ' DO: '+ Dtoc(Datup2))

etc...

Thanks.
Top

Post Reply