Tag Archives: poi

Removing Excel rows with POI

By Sebastian Basner | Published: 17. October 2016

When generating Excel Sheets it is sometimes necessary to remove rows which match a given criteria afterwards. The first idea for this would be to use removeRow(Row row) but this has the problem that it deletes all the row contents and leaves the empty row in your sheet which is probably not what you want. […]

Posted in coding, english, howto, Java | Also tagged coding, english, howto, java | Leave a comment

Using CellUtil with POI to avoid too many cell styles in Excel

By Sebastian Basner | Published: 12. September 2016

When you create Excel documents with the popular Apache POI library it is possible that you encounter a problem where Excel tells you there are “Too many different cell formats”. A possible source for this is that you probably have a loop structure in which you define a new cell style for every cell you […]