删除Excel文件中工作表的现有打印设置
Contents
[
Hide
]
可能的使用场景
有时开发人员希望阻止Excel在保存的XLSX文件中包含打印机设置的*.bin*文件。打印机设置文件位于*“[file “root”]\xl\printerSettings”*。本文介绍了如何使用Aspose.Cells API移除现有的打印机设置。
删除Excel文件中工作表的现有打印设置
Aspose.Cells允许您移除Excel文件中不同工作表的现有打印机设置。以下示例代码说明了如何移除工作簿中所有工作表的现有打印机设置。请参阅其示例Excel文件,输出Excel文件,控制台输出以及屏幕截图以供参考。
屏幕截图
示例代码
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//Source directory | |
string sourceDir = RunExamples.Get_SourceDirectory(); | |
//Output directory | |
string outputDir = RunExamples.Get_OutputDirectory(); | |
//Load source Excel file | |
Workbook wb = new Workbook(sourceDir + "sampleRemoveExistingPrinterSettingsOfWorksheets.xlsx"); | |
//Get the sheet counts of the workbook | |
int sheetCount = wb.Worksheets.Count; | |
//Iterate all sheets | |
for (int i = 0; i < sheetCount; i++) | |
{ | |
//Access the i-th worksheet | |
Worksheet ws = wb.Worksheets[i]; | |
//Access worksheet page setup | |
PageSetup ps = ws.PageSetup; | |
//Check if printer settings for this worksheet exist | |
if (ps.PrinterSettings != null) | |
{ | |
//Print the following message | |
Console.WriteLine("PrinterSettings of this worksheet exist."); | |
//Print sheet name and its paper size | |
Console.WriteLine("Sheet Name: " + ws.Name); | |
Console.WriteLine("Paper Size: " + ps.PaperSize); | |
//Remove the printer settings by setting them null | |
ps.PrinterSettings = null; | |
Console.WriteLine("Printer settings of this worksheet are now removed by setting it null."); | |
Console.WriteLine(""); | |
}//if | |
}//for | |
//Save the workbook | |
wb.Save(outputDir + "outputRemoveExistingPrinterSettingsOfWorksheets.xlsx"); |
控制台输出
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.