B4J Question jPOI set Header / Footer fields

Robert Valentino · Aug 23, 2017

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 · Aug 23, 2017

The missing piece is Sheet.getHeader or getFooter.

B4X:

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

Now you can call the methods from that link.

Privacy & Transparency