删除Excel文件中工作表的现有打印设置
Contents
[
Hide
]
可能的使用场景
有时开发者希望阻止 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文件、控制台输出以及截图作为参考。
屏幕截图
示例代码
控制台输出
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.