Ta bort befintliga utskriftsinställningar för kalkylblad i Excel filen
Möjliga användningsscenario
Ibland vill utvecklare förhindra att Excel inkluderar .bin -filer för skrivareinställningar i de sparade XLSX-filerna. Skrivareinställningsfiler finns under "[fil “rot”]\xl\printerSettings". Denna dokumentation förklarar hur man tar bort befintliga utskriftsinställningar med Aspose.Cells API: er.
Ta bort befintliga skrivareinställningar för arbetsblad i Excel-fil
Aspose.Cells tillåter dig att ta bort befintliga utskriftsinställningar specificerade för olika blad i Excel-filen. Följande exempelkod illustrerar hur man tar bort befintliga utskriftsinställningar för alla kalkylbladen i arbetsboken. Se dess prov Excel-fil, utmatnings Excel-fil, konsolresultat samt en skärmdump för referens.
Skärmdump
Exempelkod
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
//Load source Excel file | |
Workbook wb = new Workbook(srcDir + "sampleRemoveExistingPrinterSettingsOfWorksheets.xlsx"); | |
//Get the sheet counts of the workbook | |
int sheetCount = wb.getWorksheets().getCount(); | |
//Iterate all sheets | |
for(int i=0; i<sheetCount; i++) | |
{ | |
//Access the i-th worksheet | |
Worksheet ws = wb.getWorksheets().get(i); | |
//Access worksheet page setup | |
PageSetup ps = ws.getPageSetup(); | |
//Check if printer settings for this worksheet exist | |
if(ps.getPrinterSettings() != null) | |
{ | |
//Print the following message | |
System.out.println("PrinterSettings of this worksheet exist."); | |
//Print sheet name and its paper size | |
System.out.println("Sheet Name: " + ws.getName()); | |
System.out.println("Paper Size: " + ps.getPaperSize()); | |
//Remove the printer settings by setting them null | |
ps.setPrinterSettings(null); | |
System.out.println("Printer settings of this worksheet are now removed by setting it null."); | |
System.out.println(""); | |
}//if | |
}//for | |
//Save the workbook | |
wb.save(outDir + "outputRemoveExistingPrinterSettingsOfWorksheets.xlsx"); |
Konsoloutput
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.