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')[源代码]¶

基类：openpyxl.workbook.child._WorkbookChild, openpyxl.descriptors.serialisable.Serialisable

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

add_chart(chart)[源代码]¶

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()[源代码]¶

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