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:
openpyxl.workbook.child._WorkbookChild
,openpyxl.descriptors.serialisable.Serialisable
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”)
-
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’>
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'¶
-
webPublishItems
¶ Values must be of type <class ‘openpyxl.chartsheet.publish.WebPublishItems’>