Using Apache POI to Get or Create a Sheet in Excel using Java

Apache POI provides a mechanism to work with Excel documents. However, it has a missing feature when you want to only create a new sheet if one with that name doesn’t already exist. Luckily, it’s quite simple to get around this using the following code. List<String> sheets = new ArrayList<>(); for (int i = 0; i < workbook.getNumberOfSheets(); i++) { Sheet sheet = workbook.getSheetAt(i); sheets.add(sheet.getSheetName()); } Sheet sheet = sheets.contains(name) ?...

June 3, 2021 · 1 min · 127 words · Andrew