Excel 打印设置

VB C#

using IronXL;
using IronXL.Printing;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet 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");

Imports IronXL
Imports IronXL.Printing

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")
Private workSheet As 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")

Install-Package IronXL.Excel

Excel 打印设置

IronXL.Excel 中的 Excel 打印设置功能允许开发人员在打印或保存 Excel 工作表之前轻松配置其打印设置。该功能在生成报告、发票或需要特定格式打印的文档时特别有用。开发人员可以设置自定义页眉和页脚，以包含页码、标题和其他细节等动态内容，确保输出的内容专业。 PrintSetup 选项还允许对打印边距、纸张大小和方向进行微调，从而使文档适用于各种打印机和纸张类型。

IronXL为开发人员提供对打印文档外观的完全控制，能够指定纸张尺寸，如B4、A4或信纸尺寸，以及方向选项（纵向或横向）。此外，切换到黑白打印或禁用彩色打印的功能也增加了灵活性，尤其是在成本效益较高的打印场景中。该功能可简化 Excel 文件的准备过程，以便进行高质量的打印输出。

How to use Excel `NumberFormat` in C#

var workBook = WorkBook.Load("sample.xlsx");
var workSheet = workBook.DefaultWorkSheet
workSheet.Header.Center = "My Document"
workSheet.PrintSetup.PaperSize = PaperSize.B4
workSheet.PrintSetup.PrintOrientation = PrintOrientation.Portrait;
workBook.Save();

这段代码演示了如何加载 Excel 文件，修改打印设置，然后保存更改后的工作簿。它首先使用WorkBook.Load方法将“sample.xlsx”文件加载到WorkBook对象中。默认工作表可以通过DefaultWorkSheet属性访问，该属性允许脚本修改其内容和设置。具体来说，代码使用Header.Center属性将工作表的页眉设置为在中间显示“我的文档”。

代码的第二部分重点在于配置打印设置。通过PrintSetup.PaperSize属性将纸张大小设置为B4，而通过PrintSetup.PrintOrientation属性将打印方向设置为纵向模式。最后，工作簿使用workBook.Save()方法保存，应用所做的所有更改，包括更新的打印设置。该流程可用于自动编制具有自定义打印格式的 Excel 文档，确保一致的打印输出。