删除 Excel 文件中工作表的现有打印机设置
Contents
[
Hide
]
可能的使用场景
有时开发人员希望阻止 Excel 包含*。垃圾桶*保存的 XLSX 文件中的打印机设置文件。打印机设置文件位于*“[文件“root”]\xl\printerSettings”。*本文档说明如何使用 Aspose.Cells API 删除现有打印机设置。
删除 Excel 文件中工作表的现有打印机设置
Aspose.Cells 允许您删除为 Excel 文件中的不同工作表指定的现有打印机设置。以下示例代码说明了如何删除工作簿中所有工作表的现有打印机设置。请看其示例 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.