libreoffice python SDK使用教程(包括插入svg矢量图)

本文主要是介绍libreoffice python SDK使用教程(包括插入svg矢量图)，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

libreoffice python SDK使用教程

环境

centos6.9,libreoffice4.3.7.2

安装libreoffice4.3.7.2：

从https://downloadarchive.documentfoundation.org/libreoffice/old/下载libreoffice4.3.7.2及其sdk.

启动脚本

可根据以下示例写一个shell脚本启动libreoffice服务进程。

#!/bin/bash
/home/xxx/libreoffice4.3.7.2/opt/libreoffice4.3/program/soffice --calc --accept="socket,host=localhost,port=2002;urp;StarOffice.ServiceManager"

编写python code

如果libreoffice 安装到本地home下，那么启动终端运行python脚本时需要先设置PYTHONPATH.

setenv PYTHONPATH <install_path>/opt/libreoffice4.3/program  # csh
或
export PYTHONPATH=<install_path>/opt/libreoffice4.3/program  # bash

import uno
from com.sun.star.awt import Size
from com.sun.star.awt import Point
from com.sun.star.beans import PropertyValue# 获取本地设备上下文
localContext = uno.getComponentContext()
resolver = localContext.ServiceManager.createInstanceWithContext("com.sun.star.bridge.UnoUrlResolver", localContext)
# 获取服务进程设备上下文
remote_context = resolver.resolve("uno:socket,host=localhost,port=2002;urp;StarOffice.ComponentContext")
desktop = remote_context.ServiceManager.createInstanceWithContext("com.sun.star.frame.Desktop", remote_context)model = desktop.getCurrentComponent()
sheet = model.CurrentController.ActiveSheet# 向单元格写入值
cell = sheet.getCellRangeByName("C2")
cell.String = "Hello World"
cell2 = sheet.getCellRangeByName("C9")# 嵌入svg矢量图对象（非链接的方式永久写入ods中）
gra_provider= remote_context.ServiceManager.createInstanceWithContext('com.sun.star.graphic.GraphicProvider', localContext)graph = PropertyValue()
graph.Name = "URL"
graph.Value = uno.systemPathToFileUrl('/home/xxx/domo/test.svg')image_obj = gra_provider.queryGraphic((graph, )) # 传入python元组，等价于libreoffice Sequence类型image = model.createInstance('com.sun.star.drawing.GraphicObjectShape')
image.Graphic = image_objosize = image.Size
osize.Height = 6000
osize.Width = 6000
image.Size = osizeopos = image.Position
opos.X = 2000
opos.Y = 3000
image.Position = opos  # 这个值可以通过cellRange.getCellByPosition(nCol,nRow)获取到单元格的位置，然后将图片位置和单元格位置对应draw_page = sheet.DrawPage
draw_page.add(image)