Hi Reuben,
I read this article with great interest, thanks, and decided to try to take on using JAVA POI to generate excel. I'm not a java programmer at all, but your sample project and code helped and I have something working.
I'm not sure if this is the correct place to ask, but ...
What I am now looking at is the formatting of cells using the CellUtil java libraries. The reason is, using CellUtil functions you can apply additional formatting to cells that have already been created with a certain style without affecting other cells with that same style.
I can get setCellStyleProperty() to work fine, but I want to make multiple style changes on a cell - e.g. borders all round + colours, bold, etc. - so it is recommended to use setCellStyleProperties(), which I can't get to work. I am struggling with the 'Map' java type, which I understand is an Interface type (
https://docs.oracle.com/javase/8/docs/api/java/util/Map.html).The definition for this function is:-
public static void setCellStyleProperties(Cell cell,
java.util.Map<java.lang.String,java.lang.Object> properties)
Have you come across this before ? Would you be able to please explain how to declare the 'Map' and use this setCellStyleProperties function in 4GL code.
Much appreciated,
Tony.