InfoHeaderRange = infoSheet.getCellRangeByName('A1:C1') InfoSheet.getCellRangeByName('C1').String = 'Content of Named Cell Range'

InfoSheet.getCellRangeByName('B1').String = 'Name of Cell Range' InfoSheet.getCellRangeByName('A1').String = 'Operation' # Create a new sheet to store our output informationĭoc.Sheets.insertNewByName('Information', 1) # Create a blank spreadsheet document, instead of damaging the existing document.ĭoc = desktop.loadComponentFromURL('private:factory/scalc', '_blank', 0, ()) '''The main function to be shown on the user interface.'''ĭesktop = smgr.createInstanceWithContext('.Desktop', ctx) # (.CellRangeAddress)ĭoc.NamedRanges.addNewByName(aName, aContent, aPosition, 0) # the index of the sheet in the doc, 0-basedĪPosition.Sheet = sheet.getRangeAddress().SheetĪddressObj = sheet.getCellRangeByName(rangeReference) # If the named range exists, then update itĭoc.NamedRanges.getByName(rangeName).setContent(aContent)ĪPosition = uno.createUnoStruct('.CellAddress') SheetName = '$' + SheetName.replace('$', '')ĪContent = sheetName + '.' + rangeReference

# make sure the sheet name starts with '$' If the named range exists in the document, thenĮxample: DefineNamedRange(doc, 'Sheet1', 'test_range', '$A$1:$F$14'). If a copy of the MPL was not distributed with thisįrom import NoSuchElementExceptionĭef DefineNamedRange(doc, SheetName, rangeName, rangeReference): # This Source Code Form is subject to the terms of the Mozilla Public # This file is part of the LibreOffice project.

Libreoffice base python