// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet1 = workbook.getWorksheets().get(0); IWorksheet worksheet2 = workbook.getWorksheets().add(); Object data = new Object[][] { {1, 2, 3}, {4, 5, 6}, {7, 8, 9} }; worksheet1.getRange("A1:C3").setValue(data); worksheet2.getRange("A1:C3").setValue(data); //Insert cells worksheet1.getRange("A2").insert();//Auto worksheet1.getRange("B2").insert(InsertShiftDirection.Down); worksheet1.getRange("C2").insert(InsertShiftDirection.Right); //Delete cells worksheet2.getRange("A2").delete();//Auto worksheet2.getRange("B2").delete(DeleteShiftDirection.Left); worksheet2.getRange("C2").delete(DeleteShiftDirection.Up); // Save to an excel file workbook.save("InsertCellsDeleteCells.xlsx");