Url = uno.systemPathToFileUrl(os.path.abspath(file_path))įormat_filter = uno.createUnoStruct('.PropertyValue')įormat_filter.Value = 'Calc MS Excel 2007 XML'įormat_filter.Value = 'Calc MS Excel 2007 Binary'įormat_filter.Value = 'Office Open XML Spreadsheet' The saveas xlsb is ‘Calc MS Excel 2007 Binary’ according to filters - OpenGrok cross reference for /core/filter/source/config/fragments/filters/ def save_workbook_as(self, file_path): To save into another format (workbook method), you have to define the desired format from a predefined list. CalcWorkbook is another class I created to wrap workbook methods, and so on.

Return CalcWorkbook(pyuno_workbook, self.shared) Pyuno_workbook = pyuno_desktop.getCurrentComponent() Pyuno_desktop = smgr.createInstanceWithContext('.Desktop', context) For example, to open a workbook I do: def open_file(self, file_path):

I combine this pyoo methods with the raw UNO ones, because sometimes I don’t find what I need in pyoo. Note that I am using the pyoo library to get the desktop component, which is something similar to the com connection you established for excel as xl. Return 'Unable to connect to LibreOffice server' Self.lo_process = subprocess.Popen(starter)ĭesktop = pyoo.Desktop('localhost', port) Starter = (['soffice', '-accept=socket,host=localhost,port=2002 urp ', # range from one sheet of the workbook to another one

# objects sharing among the calc related objects. # The following 'shared' attribute is intended to provide safe

I use the following to get an instance of libreoffice: class CalcObject: I personally created python classes to wrap spreadsheet actions, one for excel and one for calc, so that they share the same method names for doing the same tasks, and then I can interchange them (I use excel while in Windows and calc while in Linux). The analog for the com connection you are doing with excel is connecting with a running soffice, only that obviously the methods in a soffice instance are not the same as the ones in an excel instance.

Python libreoffice writer