Filter and Freeze top row in Apache POI

If you make spreadsheets with POI that people are going to use, you definitely will want to enable these two excel features (filtering and freezing the header row):

sheet.setAutoFilter(new CellRangeAddress(0, 0, 0, numColumns))
sheet.createFreezePane(0, 1)

Leave a Reply

Your email address will not be published. Required fields are marked *