//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); //Set data of PC worksheet.getRange("A2").setValue("PC"); worksheet.getRange("A4:C4").setValue(new String[] {"Device", "Quantity", "Unit Price"}); worksheet.getRange("A5:C10").setValue(new Object[][] { {"T540p", 12, 9850}, {"T570", 5, 7460}, {"Y460", 6, 5400}, {"Y460F", 8, 6240} }); //Set style worksheet.getRange("A2").setRowHeight(30); worksheet.getRange("A2").getFont().setSize(20); worksheet.getRange("A2").getFont().setBold(true); worksheet.getRange("A4:C4").getFont().setBold(true); worksheet.getRange("A4:C4").getFont().setColor(Color.GetWhite()); worksheet.getRange("A4:C4").getInterior().setColor(Color.GetLightBlue()); worksheet.getRange("A5:C10").getBorders().get(BordersIndex.InsideHorizontal).setColor(Color.GetOrange()); worksheet.getRange("A5:C10").getBorders().get(BordersIndex.InsideHorizontal).setLineStyle(BorderLineStyle.DashDot); //Copy only style and row height worksheet.getRange("H1").setValue("Copy style and row height from previous cells."); worksheet.getRange("H1").getFont().setColor(Color.GetRed()); worksheet.getRange("H1").getFont().setBold(true); worksheet.getRange("A2:C10").copy(worksheet.getRange("H2"), EnumSet.of(PasteType.Formats)); //Set data of mobile devices worksheet.getRange("H2").setValue("Mobile"); worksheet.getRange("H4:J4").setValue(new String[] {"Device", "Quantity", "Unit Price"}); worksheet.getRange("H5:J10").setValue(new Object[][] { {"HW-P30", 20, 4200}, {"IPhone-X", 5, 9888}, {"IPhone-6s plus", 15, 6880} }); //Add new sheet IWorksheet worksheet2 =workbook.getWorksheets().add(); //Copy only style to new sheet worksheet.getRange("A2:C10").copy(worksheet2.getRange("A2"), EnumSet.of(PasteType.Formats)); worksheet2.getRange("A3").setValue("Copy style from sheet1."); worksheet2.getRange("A3").getFont().setColor(Color.GetRed()); worksheet2.getRange("A3").getFont().setBold(true); //save to an excel file workbook.save("CopyPasteOptions.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) //Set data of PC worksheet.getRange("A2").value = "PC" worksheet.getRange("A4:C4").value = arrayOf("Device", "Quantity", "Unit Price") worksheet.getRange("A5:C10").value = arrayOf(arrayOf("T540p", 12, 9850), arrayOf("T570", 5, 7460), arrayOf("Y460", 6, 5400), arrayOf("Y460F", 8, 6240)) //Set style worksheet.getRange("A2").rowHeight = 30.0 worksheet.getRange("A2").font.size = 20.0 worksheet.getRange("A2").font.bold = true worksheet.getRange("A4:C4").font.bold = true worksheet.getRange("A4:C4").font.color = Color.GetWhite() worksheet.getRange("A4:C4").interior.color = Color.GetLightBlue() worksheet.getRange("A5:C10").borders.get(BordersIndex.InsideHorizontal).color = Color.GetOrange() worksheet.getRange("A5:C10").borders.get(BordersIndex.InsideHorizontal).lineStyle = BorderLineStyle.DashDot //Copy only style and row height worksheet.getRange("H1").value = "Copy style and row height from previous cells." worksheet.getRange("H1").font.color = Color.GetRed() worksheet.getRange("H1").font.bold = true worksheet.getRange("A2:C10").copy(worksheet.getRange("H2"), EnumSet.of(PasteType.Formats)) //Set data of mobile devices worksheet.getRange("H2").value = "Mobile" worksheet.getRange("H4:J4").value = arrayOf("Device", "Quantity", "Unit Price") worksheet.getRange("H5:J10").value = arrayOf(arrayOf("HW-P30", 20, 4200), arrayOf("IPhone-X", 5, 9888), arrayOf("IPhone-6s plus", 15, 6880)) //Add new sheet val worksheet2 = workbook.worksheets.add() //Copy only style to new sheet worksheet.getRange("A2:C10").copy(worksheet2.getRange("A2"), EnumSet.of(PasteType.Formats)) worksheet2.getRange("A3").value = "Copy style from sheet1." worksheet2.getRange("A3").font.color = Color.GetRed() worksheet2.getRange("A3").font.bold = true //save to an excel file workbook.save("CopyPasteOptions.xlsx")