//create a new workbook Workbook workbook = new Workbook(); //Load template file Home inventory.xlsx from resource Workbook source_workbook = new Workbook(); InputStream source_fileStream = this.getResourceStream("xlsx/Home inventory.xlsx"); source_workbook.open(source_fileStream); //Hide gridline workbook.getActiveSheet().getSheetView().setDisplayGridlines(false); workbook.getActiveSheet().getRange("A1").setValue("Copy content from the first sheet of source workbook"); workbook.getActiveSheet().getRange("A1").getFont().setColor(Color.GetRed()); workbook.getActiveSheet().getRange("A1").getFont().setBold(true); //Copy content of active sheet from source workbook to the current sheet at A2 source_workbook.getActiveSheet().getUsedRange(EnumSet.allOf(UsedRangeType.class)).copy(workbook.getActiveSheet().getRange("A2"), EnumSet.of(PasteType.Formulas, PasteType.Formats, PasteType.RowHeights, PasteType.ColumnWidths)); workbook.getActiveSheet().getRange("C21").setValue("Cut content from the second sheet of source workbook"); workbook.getActiveSheet().getRange("C21").getFont().setColor(Color.GetRed()); workbook.getActiveSheet().getRange("C21").getFont().setBold(true); //Cut content of second sheet from source workbook to the current sheet at C22 source_workbook.getWorksheets().get(1).getRange("2:15").cut(workbook.getActiveSheet().getRange("C22")); //Make the theme of two workbooks same workbook.setTheme(source_workbook.getTheme()); //save to an excel file workbook.save("CutCopyRangeBetweenWorkbooks.xlsx");
//create a new workbook var workbook = Workbook() //Load template file Home inventory.xlsx from resource val source_workbook = Workbook() val source_fileStream = this.getResourceStream("xlsx/Home inventory.xlsx") source_workbook.open(source_fileStream!!) //Hide gridline workbook.activeSheet.sheetView.displayGridlines = false workbook.activeSheet.getRange("A1").value = "Copy content from the first sheet of source workbook" workbook.activeSheet.getRange("A1").font.color = Color.GetRed() workbook.activeSheet.getRange("A1").font.bold = true //Copy content of active sheet from source workbook to the current sheet at A2 source_workbook.activeSheet.getUsedRange(EnumSet.allOf(UsedRangeType::class.java)).copy(workbook.activeSheet.getRange("A2"), EnumSet.of(PasteType.Formulas, PasteType.Formats, PasteType.RowHeights, PasteType.ColumnWidths)) workbook.activeSheet.getRange("C21").value = "Cut content from the second sheet of source workbook" workbook.activeSheet.getRange("C21").font.color = Color.GetRed() workbook.activeSheet.getRange("C21").font.bold = true //Cut content of second sheet from source workbook to the current sheet at C22 source_workbook.worksheets.get(1).getRange("2:15").cut(workbook.activeSheet.getRange("C22")) //Make the theme of two workbooks same workbook.theme = source_workbook.theme //save to an excel file workbook.save("CutCopyRangeBetweenWorkbooks.xlsx")