Python (pyuno) "Hello World" Addon for OpenOffice

 1 import uno
 2 import unohelper
 3 
 4 from com.sun.star.task import XJobExecutor
 5 
 6 # Implement an UNO component by deriving from the standard
 7 # unohelper.Base class and from the interface(s) you want to implement.
 8 class HelloWorldJob(unohelper.Base, XJobExecutor):
 9     def __init__(self, ctx):
10         # store the component context for later use
11         self.ctx = ctx
12 
13     def trigger(self, args):
14         # Retrieve the desktop object
15         desktop = self.ctx.ServiceManager.createInstanceWithContext("com.sun.star.frame.Desktop", self.ctx)
16 
17         # Get the spreadsheet.
18         spreadsheet = desktop.getCurrentComponent()
19 
20         # Get the collection of sheets in the spreadsheet.
21         sheets = spreadsheet.getSheets()
22 
23         # Get the first cell in the first sheet.
24         cell = sheets.getByIndex(0).getCellByPosition(0, 0)
25 
26         # Modify its contents.
27         if cell.getFormula():
28             cell.setFormula("Hello " + cell.getFormula())
29         else:
30             cell.setFormula("Hello world")
31 
32 
33 # pythonloader looks for a static g_ImplementationHelper variable
34 g_ImplementationHelper = unohelper.ImplementationHelper()
35 
36 g_ImplementationHelper.addImplementation( \
37         HelloWorldJob,                                # UNO object class
38         "org.openoffice.comp.pyuno.demo.HelloWorld",  # Implementation name
39         ("com.sun.star.task.Job",),)                  # List of implemented services

<?xml version="1.0" encoding="UTF-8"?>
<oor:node xmlns:oor="http://openoffice.org/2001/registry"
             xmlns:xs="http://www.w3.org/2001/XMLSchema"
             oor:name="Addons" oor:package="org.openoffice.Office">
  <node oor:name="AddonUI">
    <node oor:name="AddonMenu">
      <node oor:name="org.openoffice.comp.pyuno.demo.HelloWorld" oor:op="replace">
        <prop oor:name="URL" oor:type="xs:string">
          <value>service:org.openoffice.comp.pyuno.demo.HelloWorld?insert</value>
        </prop>
        <prop oor:name="ImageIdentifier" oor:type="xs:string">
          <value>private:image/3216</value>
        </prop>
        <prop oor:name="Title" oor:type="xs:string">
          <value xml:lang="en-US">Insert Hello World</value>
        </prop>
      </node>
    </node>
  </node>
</oor:node>

#!/bin/bash

unopkg_bin=/usr/bin/unopkg
oocalc_bin=/usr/bin/oocalc

addons=Addons.xcu
python_file=hello_world_oocalc.py
zip_file=hello_world.zip

rm $zip_file
zip $zip_file $addons $python_file
$unopkg_bin remove $zip_file
$unopkg_bin add $zip_file

#export PYUNO_LOGLEVEL=CALL
export PYUNO_LOGLEVEL=ARGS
export PYUNO_LOGTARGET=stdout

$oocalc_bin