删除Excel文件中工作表的现有打印设置

可能的使用场景

有时开发者希望阻止 Excel 在保存的 XLSX 文件中包含 .bin 格式的打印机设置文件。打印机设置文件位于 “[file “root”]\xl\printerSettings” 位置。本文介绍如何使用 Aspose.Cells for Python via .NET API 移除现有的打印机设置。

删除Excel文件中工作表的现有打印设置

Aspose.Cells for Python via .NET 允许你删除为Excel文件中不同工作表指定的现有打印机设置。以下示例代码演示如何删除工作簿中所有工作表的现有打印机设置。请参阅其sample Excel文件输出Excel文件、控制台输出以及截图作为参考。

屏幕截图

todo:image_alt_text

示例代码

控制台输出

 PrinterSettings of this worksheet exist.

Sheet Name: Sheet1

Paper Size: PaperLegal

Printer settings of this worksheet are now removed by setting it null.

PrinterSettings of this worksheet exist.

Sheet Name: Sheet2

Paper Size: PaperEnvelopeB5

Printer settings of this worksheet are now removed by setting it null.

PrinterSettings of this worksheet exist.

Sheet Name: Sheet3

Paper Size: PaperA6

Printer settings of this worksheet are now removed by setting it null.

PrinterSettings of this worksheet exist.

Sheet Name: Sheet4

Paper Size: PaperA3

Printer settings of this worksheet are now removed by setting it null.