Wizard of X

Between the holidays and some deadline pressure, it's taken longer to get to this than I'd like. But at last, here it is. This is my CellStyleManager and CellStyles enum. public class CellStyleManager {     public static final int BORDERLOC_NONE = 0;     public static final int BORDERLOC_TOP = 1;     public static final int BORDERLOC_BOTTOM = 2;     public static final int BORDERLOC_LEFT = 4;     public static final int BORDERLOC_RIGHT = 8;     public static final int BORDERLOC_ALL = BORDERLOC_BOTTOM | BORDERLOC_TOP | BORDERLOC_LEFT | BORDERLOC_RIGHT;     public static final int BORDERLOC_SIDES = BORDERLOC_LEFT | BORDERLOC_RIGHT;     public static final int BORDERLOC_TB = BORDERLOC_TOP | BORDERLOC_BOTTOM;     private final Workbook wb;     private final Map<cellstyles cellstyle=""> styleMap;     private final FontManag...

Part 1 was just laying some foundation. Now it's time to tackle some of the more troublesome bits of managing XLSX through POI. The first challenge I wanted to tackle is how to define Fonts and CellStyles. Every time you create one of these elements, it gets added to the .xlsx file, even if it is a duplicate of something you've already created. Also, there is a maximum number of each, so if you create your cells dynamically, you can run out of room to create new cells. You can get around this by first creating your spreadsheet, and then applying styling to groups of cells. Buy my goal was dynamic reports. I want to write a report without knowing what kind of data is going to be in each row or cell.

I've been working on this project for about two years off and on now. Some parts of it shaped up early on, while others have undergone significant refactoring. Most of my reports are in Excel, but some few are done in Word. So I started with a class that accepts any POI XML document and a file name, and sends that file to the browser.