//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");
//create a new workbook var workbook = Workbook() val worksheet1 = workbook.worksheets.get(0) val worksheet2 = workbook.worksheets.add() val data = arrayOf(arrayOf(1, 2, 3), arrayOf(4, 5, 6), arrayOf(7, 8, 9)) worksheet1.getRange("A1:C3").value = data worksheet2.getRange("A1:C3").value = 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")