Open.office read only
Posted: 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
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