openpyxl.chartsheet.chartsheet module

class openpyxl.chartsheet.chartsheet.Chartsheet(sheetPr=None, sheetViews=None, sheetProtection=None, customSheetViews=None, pageMargins=None, pageSetup=None, headerFooter=None, drawing=None, drawingHF=None, picture=None, webPublishItems=None, extLst=None, parent=None, title='', sheet_state='visible')[source]

Bases: _WorkbookChild, Serialisable

HeaderFooter: Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)

add_chart(chart)[source]

customSheetViews: Values must be of type <class ‘openpyxl.chartsheet.custom.CustomChartsheetViews’>

drawing: Values must be of type <class ‘openpyxl.worksheet.drawing.Drawing’>

drawingHF: Values must be of type <class ‘openpyxl.chartsheet.relation.DrawingHF’>

extLst: Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

headerFooter: Values must be of type <class ‘openpyxl.worksheet.header_footer.HeaderFooter’>

mime_type = 'application/vnd.openxmlformats-officedocument.spreadsheetml.chartsheet+xml'

pageMargins: Values must be of type <class ‘openpyxl.worksheet.page.PageMargins’>

pageSetup: Values must be of type <class ‘openpyxl.worksheet.page.PrintPageSetup’>

picture: Values must be of type <class ‘openpyxl.chartsheet.relation.SheetBackgroundPicture’>

sheetPr: Values must be of type <class ‘openpyxl.chartsheet.properties.ChartsheetProperties’>

sheetProtection: Values must be of type <class ‘openpyxl.chartsheet.protection.ChartsheetProtection’>

sheetViews: Values must be of type <class ‘openpyxl.chartsheet.views.ChartsheetViewList’>

sheet_state: Value must be one of {‘hidden’, ‘visible’, ‘veryHidden’}

tagname = 'chartsheet'

to_tree()[source]

webPublishItems: Values must be of type <class ‘openpyxl.chartsheet.publish.WebPublishItems’>