Python Xlsxwriter 简明教程
Python XlsxWriter - Header & Footer
当使用上述方法打印工作表时, header 和 footer 将在纸上生成。打印预览还显示页眉和页脚。两者均使用 set_header() 和 set_footer() 方法进行配置。页眉和页脚字符串通过以下控制字符进行配置 −
When the worksheet is printed using the above methods, the header and footer are generated on the paper. The print preview also displays the header and footer. Both are configured with set_header() and set_footer() methods. Header and footer string is configured by following control characters −
Control |
Category |
Description |
&L |
Justification |
Left |
&C |
Center |
|
&R |
Right |
|
&P |
Information |
Page number |
&N |
Total number of pages |
|
&D |
Date |
|
&T |
Time |
|
&F |
File name |
|
&A |
Worksheet name |
|
&Z |
Workbook path |
|
&fontsize |
Font |
Font size |
&"font,style" |
Font name and style |
|
&U |
Single underline |
|
&E |
Double underline |
|
&S |
Strikethrough |
|
&X |
Superscript |
|
&Y |
Subscript |
|
&[Picture] |
Images |
Image placeholder |
&G |
Same as &[Picture] |
|
&& |
Misc. |
Literal ampersand "&" |
Example
以下代码使用 set_header() 和 set_footer() 方法 −
The following code uses set_header() and set_footer() methods −
import xlsxwriter
wb = xlsxwriter.Workbook('hello.xlsx')
ws = wb.add_worksheet()
data = [
['Anil', 45, 55, 50], ['Ravi', 60, 70, 80],
['Kiran', 65, 75, 85],['Karishma', 55, 65, 45]
]
for row in range(len(data)):
ws.write_row(row,0, data[row])
header1 = '&CTutorialspoint'
footer1 = '&LSimply Easy Learning'
ws.set_landscape()
ws.set_paper(9) #A4 paper
ws.set_header(header1)
ws.set_footer(footer1)
ws.set_column('A:A', 50)
wb.close()