Apache POI Excel Cell Properties
Sometimes we want to create a spreadsheet with basic styles and then apply special styles to certain cells such as drawing borders around a range of cells or setting fills for a region. Apache POI provides CellUtil.setCellProperties which allows us to do that without creating a bunch of unnecessary intermediate styles in our spreadsheet.
Properties are created as a Map and applied to a cell.
Lets see an example in which we are applying special styles to certain cell.
Apache POI Excel Cell Properties Example