This does not include the source code of LibreOffice, which is licensed under the GNU Lesser General Public License ( LGPLv3). Please note that all contributions to The Document Foundation Wiki are considered to be released under the Creative Commons Attribution-ShareAlike 3.0 Unported License, unless otherwise specified.Based on work by Ilmari Lauhakangas and Mauricio Baeza and others. This page was last edited 17:15, 1 July 2022 by B.ImportSheet(SOURCE, SOURCE_NAME, POSITION)ĭesktop = app.create_instance('.Desktop', True)ĭoc = desktop.loadComponentFromURL(path, '_default', 0, ())ĭoc.Sheets.importSheet(source, 'Services', 0)Ĭopy or import the function get_color from Useful functions This function replaces a sheet NAME with a clean sheet.ĬopyByName(SOURCE_NAME, NEW_NAME, POSITION)ĬAUTION: If new name exists, it will copy the sheet with name SOURCE_NAME_2, and it will not get any error.ĭoc.pyByName('data', 'NewData', 10) Sheet = doc.createInstance('.Spreadsheet')ĬAUTION: Use wisely. Set property IsVisible to False to hide a sheet and set it to True to show it.Get active sheet by name from current documentĭoc.getCurrentController().setActiveSheet(sheet).

Get active sheet by index from current document.

Sheet = doc.getCurrentController().getActiveSheet()

Get active sheet from current document.

sheet is a single spreadsheet within a documentĬopy or import function msgbox from Useful functions Names.In this Python Guide, we use the following convention:

Libreoffice calc python