Robert Valentino Well-Known Member Licensed User Longtime User Aug 23, 2017 #1 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
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 B4X founder Staff member Licensed User Longtime User Aug 23, 2017 #2 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. Upvote 0
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.