Remove Existing PrinterSettings of Worksheets in Excel file

Possible Usage Scenarios

Sometimes developers want to prevent Excel from including .bin files of printer settings in the saved XLSX files. Printer settings files are located under “[file “root”]\xl\printerSettings”. This document explains how to remove existing printer settings using Aspose.Cells APIs.

Remove Existing PrinterSettings of Worksheets in Excel file

Aspose.Cells allows you to remove existing printer settings specified for different sheets in the Excel file. The following sample code illustrates how to remove existing printer settings for all the worksheets in the workbook. Please see its sample Excel file, output Excel file, console output as well as the screenshot for reference.

Screenshot

Sample Code

Console Output

  

PrinterSettings of this worksheet exists.  

Sheet Name: Sheet1  

Paper Size: PaperLegal  

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

PrinterSettings of this worksheet exists.  

Sheet Name: Sheet2  

Paper Size: PaperEnvelopeB5  

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

PrinterSettings of this worksheet exists.  

Sheet Name: Sheet3  

Paper Size: PaperA6  

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

PrinterSettings of this worksheet exists.  

Sheet Name: Sheet4  

Paper Size: PaperA3  

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