B4J Question [Solved]Use of XLUtils PrintSetup method

[bdunkleysmith]

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.

 

[bdunkleysmith]

Looking at these references: https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFPrintSetup.html and https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/PaperSize.html

I found this code does the job:

    Dim PrintSetup = sheet1.PrintSetup As JavaObject
    PrintSetup.RunMethod("setPaperSize", Array As Object("A4_PAPER"))