I note in this library post XLUtils / jPOI 5 - Read and write MS Excel workbooks it says v1.12 - New methods and properties: XLSheetWriter.SetFitToPage, PrintSetup and PrintArea. however I can find no example of how the PrintSetup method is used.
Currently when I create a workbook/worksheet with this library, the print setup dialog in Excel shows the page size as Letter, but I would like to set it to A4 programmatically rather than change to change it manually each time. I assumed using the PrintSetup method may be an appropriate way to do this.
Any guidance would be appreciated.
Currently when I create a workbook/worksheet with this library, the print setup dialog in Excel shows the page size as Letter, but I would like to set it to A4 programmatically rather than change to change it manually each time. I assumed using the PrintSetup method may be an appropriate way to do this.
Any guidance would be appreciated.