set print titles and print area with python

Naive_Bayes616

于 2022-06-30 22:03:42 发布

阅读量324

点赞数

文章标签：大数据

本文链接：https://blog.youkuaiyun.com/qq_27180927/article/details/125549110

版权

这段代码演示了如何使用openpyxl库在Python中设置Excel工作表的打印标题行和打印区域。`print_title_rows`设定为'1:3'表示前三行为打印标题行，`print_title_cols`设定为'A:B'意味着第一和第二列也是标题列。此外，`print_area`设置为'A1:F10'，这意味着仅打印从A1到F10的区域。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import openpyxl
wb = openpyxl.load_workbook('printtitle.xlsx')
ws = wb['Sheet0']
#Add Print Titles
#You can print titles on every page to ensure that the data is properly labelled.
ws.print_title_rows = '1:3' # the first row
ws.print_title_cols = 'A:B' # the first two cols
#Add a Print Area
#You can select a part of a worksheet as the only part that you want to print
ws.print_area = 'A1:F10'
wb.save('print_area_test.xlsx')