删除Excel文件中工作表的现有打印设置
Contents
[
Hide
]
可能的使用场景
有时开发人员希望防止Excel在保存的XLSX文件中包含打印设置的*.bin*文件。打印设置文件位于“[file “root”]\xl\printerSettings”下。本文档介绍了如何使用Aspose.Cells API删除现有的打印设置。
删除Excel文件中工作表的现有打印设置
Aspose.Cells允许您删除Excel文件中不同工作表指定的现有打印设置。以下示例代码说明了如何删除工作簿中所有工作表的现有打印设置。请参阅其示例Excel文件、输出Excel文件、控制台输出以及参考的屏幕截图。
屏幕截图
示例代码
控制台输出
PrinterSettings of this worksheet exist.
Sheet Name: Sheet1
Paper Size: 5
Printer settings of this worksheet are now removed by setting it null.
PrinterSettings of this worksheet exist.
Sheet Name: Sheet2
Paper Size: 34
Printer settings of this worksheet are now removed by setting it null.
PrinterSettings of this worksheet exist.
Sheet Name: Sheet3
Paper Size: 70
Printer settings of this worksheet are now removed by setting it null.
PrinterSettings of this worksheet exist.
Sheet Name: Sheet4
Paper Size: 8
Printer settings of this worksheet are now removed by setting it null.