Excel打印设置

from ironxl import *

# Load the Excel workbook
workbook = WorkBook.Load("sample.xlsx")
worksheet = workbook.DefaultWorkSheet

# Set the print header and footer of the worksheet
worksheet.Header.Center = "My document"
worksheet.Footer.Center = "Page &P of &N"

# Set the header margin
worksheet.PrintSetup.HeaderMargin = 2.33

# Set the size of the paper
# Paper size enum represents different sizes of paper
worksheet.PrintSetup.PaperSize = PaperSize.B4

# Set the print orientation of the worksheet
worksheet.PrintSetup.PrintOrientation = PrintOrientation.Portrait

# Set black and white printing
worksheet.PrintSetup.NoColor = True

workbook.SaveAs("PrintSetup.xlsx")

pip install ironxl

pip install ironxl

Excel打印设置

IronXL中的Excel打印设置功能使Python开发人员可以在打印或将其保存为PDF之前，为Excel工作表配置打印设置。这在生成需要特定格式以进行打印输出的报告、发票或文档时特别有用。开发人员可以设置带有动态内容的自定义页眉和页脚，例如页码和标题，确保专业的结果。 PrintSetup选项还允许对边距、纸张大小和方向进行微调，使文件可以适应各种打印机和纸张类型。

IronXL提供对打印布局的完全控制，包括B4、A4以及信纸的纸张大小，以及纵向和横向的方向。启用黑白打印的选项为经济高效的打印场景增加了灵活性。此功能简化了直接从Python准备Excel文件以获得高质量打印输出的过程。