//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IWorksheet worksheet2 = workbook.getWorksheets().add(); worksheet.getRange("B3:D12").setValue(5); worksheet.getRange("B3:D12").getInterior().setColor(Color.GetLightGreen()); //Copy worksheet.getRange("B3:D12").copy(worksheet.getRange("E5")); //Cut worksheet.getRange("B3:D12").cut(worksheet.getRange("I5:K14")); worksheet.getRange("I1:K2").setValue(2); worksheet.getRange("I1:K2").getInterior().setColor(Color.GetPink()); //cross sheet cut copy. worksheet.getRange("I1:K2").cut(worksheet2.getRange("H5")); worksheet.getRange("G4:H5").copy(worksheet2.getRange("A1")); //save to an excel file workbook.save("CutCopyRange.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val worksheet2 = workbook.worksheets.add() worksheet.getRange("B3:D12").value = 5 worksheet.getRange("B3:D12").interior.color = Color.GetLightGreen() //Copy worksheet.getRange("B3:D12").copy(worksheet.getRange("E5")) //Cut worksheet.getRange("B3:D12").cut(worksheet.getRange("I5:K14")) worksheet.getRange("I1:K2").value = 2 worksheet.getRange("I1:K2").interior.color = Color.GetPink() //cross sheet cut copy. worksheet.getRange("I1:K2").cut(worksheet2.getRange("H5")) worksheet.getRange("G4:H5").copy(worksheet2.getRange("A1")) //save to an excel file workbook.save("CutCopyRange.xlsx")