How to create page borders using Apache POI in excel files with Java

Question

In my application, I've been using Apache POI to generate excel invoices and reports. The report uses several font sizes, bordered and non-bordered cells, varied foreground and background colours, and numerous cell layouts. Page borders are a new requirement that I must include. I have examined the majority of the samples. I was unable to locate sample code for the entire page; only for cell-level boundaries.

In OpenOffice/Libre Office excel applications this can be achieved by going to Format>Page>Border and selecting options as in the image below

page border

Can someone please help me with this?

Answer 1

Microsoft Excel cannot do this. Libreoffice Calc and Openoffice Calc can. But if you save in Calc as *.xlsx format, then the page border lines will not be saved. So there is no place in *.xlsx for saving page borderlines. Saved as *.ods the page border lines will be saved, but apache-poi is not supposed to deal with *.ods files.