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

最新推荐文章于 2024-04-12 21:23:13 发布

司拓

最新推荐文章于 2024-04-12 21:23:13 发布

阅读量1.6k

点赞数 1

分类专栏： Linux开发文章标签： python libreoffice sdk

本文链接：https://blog.csdn.net/Situo/article/details/121890888

版权

Linux开发专栏收录该内容

7 篇文章 0 订阅

订阅专栏

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_obj

osize = image.Size
osize.Height = 6000
osize.Width = 6000
image.Size = osize

opos = image.Position
opos.X = 2000
opos.Y = 3000
image.Position = opos  # 这个值可以通过cellRange.getCellByPosition(nCol,nRow)获取到单元格的位置，然后将图片位置和单元格位置对应

draw_page = sheet.DrawPage
draw_page.add(image)