openpyxl provides reasonably full support for print settings.
>>> from openpyxl.workbook import Workbook >>> >>> wb = Workbook() >>> ws = wb.active >>> >>> ws.print_options.horizontalCentered = True >>> ws.print_options.verticalCentered = True
Headers and footers use their own formatting language. This is fully supported when writing them but, due to the complexity and the possibility of nesting, only partially when reading them. There is support for the font, size and color for a left, centre/center, or right element. Granular control (highlighting individuals words) will require applying control codes manually.
>>> from openpyxl.workbook import Workbook >>> >>> wb = Workbook() >>> ws = wb.active >>> >>> ws.oddHeader.left.text = "Page &[Page] of &N" >>> ws.oddHeader.left.size = 14 >>> ws.oddHeader.left.font = "Tahoma,Bold" >>> ws.oddHeader.left.color = "CC3366"
Also supported are evenHeader and evenFooter 及 firstHeader and firstFooter .
You can print titles on every page to ensure that the data is properly labelled.
>>> from openpyxl.workbook import Workbook >>> >>> wb = Workbook() >>> ws = wb.active >>> >>> ws.print_title_cols = 'A:B' # the first two cols >>> ws.print_title_rows = '1:1' # the first row
You can select a part of a worksheet as the only part that you want to print
>>> from openpyxl.workbook import Workbook >>> >>> wb = Workbook() >>> ws = wb.active >>> >>> ws.print_area = 'A1:F10'
