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: Values must be of type <class ‘openpyxl.worksheet.header_footer.HeaderFooter’>

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 {‘visible’, ‘hidden’, ‘veryHidden’}

tagname = 'chartsheet'

to_tree()[source]

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