Calling basic libraries in python to Open Microsoft Excel

English
, ,
#1

Good Afternoon,

I would like to know how I can call GlobalScope.BasicLibraries.loadLibrary(“Tools”) from within python. My goal is to open an Excel (xlsx) file through python in a manner similar to what is described in
How to open MS excel file in Libre office macro - English - Ask LibreOffice

Thank you for your assistance.

#2

Calling Basic Macros from Python

#4

thank you very much. i will take a look at this.

#3

Why Basic? Just open the file in Python.

import uno
gPathName = '/tmp/test/DDE_Source.ods'

def test_OpenFile():
    url = uno.systemPathToFileUrl(gPathName)
    ctx = XSCRIPTCONTEXT.getComponentContext()
    smgr = ctx.ServiceManager
    dtp = smgr.createInstance('com.sun.star.frame.Desktop')
    doc = dtp.loadComponentFromURL(url, '_default', 0, ())
2 Likes
#5

So using this code I can open Excel? I am away from a computer presently.

#6

The same code with another path name can open Excel documents (not Excel itself).

1 Like
#7

Yes. Sorry for being vague. Excel documents.

#8

Yes it works. Thank you for your assistance.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.