ApressJavaCode
diff --git a/‎apache-poi/src/main/java/com/baeldung/poi/excel/insert/InsertRowHelper.java‎
Lines changed: 21 additions & 0 deletions b/‎apache-poi/src/main/java/com/baeldung/poi/excel/insert/InsertRowHelper.java‎
Lines changed: 21 additions & 0 deletions
@@ -0,0 +1,21 @@
+package com.baeldung.poi.excel.insert;
+
+import org.apache.poi.ss.usermodel.Sheet;
+import org.apache.poi.ss.usermodel.Workbook;
+import org.apache.poi.xssf.usermodel.XSSFWorkbook;
+
+import java.io.IOException;
+
+public class InsertRowHelper {
+    public Workbook insertRowBetweenRows(String fileLocation, int startRow, int rowNumber) throws IOException {
+        Workbook workbook = new XSSFWorkbook(fileLocation);
+        Sheet sheet = workbook.getSheetAt(0);
+        int lastRow = sheet.getLastRowNum();
+        if (lastRow < startRow) {
+            sheet.createRow(startRow);
+        }
+        sheet.shiftRows(startRow, lastRow, rowNumber, true, true);
+        sheet.createRow(startRow);
+        return workbook;
+    }
+}