B4J Question jPOI set Header / Footer fields

[Robert Valentino]

I would like to set the Header / Footer fields on an Excel file

setLeft, setCenter, setRight http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/HeaderFooter.html

Want to set the Page number, date and stuff like that

BobVal

 

[Erel]

The missing piece is Sheet.getHeader or getFooter.

Dim sheetJo As JavaObject = Sheet1
Dim header As JavaObject = sheetJo.RunMethod("getHeader", Null)

Now you can call the methods from that link.