Open.office read only

HMG Samples and Enhancements

Moderator: Rathinagiri

Post Reply
User avatar
nekbmm
Posts: 118
Joined: Sat Jul 16, 2016 3:16 am
DBs Used: DBF,SQLite
Location: Ivanjica, Serbia

Open.office read only

Post by nekbmm »

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