//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1").setStyle(workbook.getStyles().get("Good")); worksheet.getRange("A1").setValue("Good"); // Create and modify a style based on current existing style IStyle myGood = workbook.getStyles().add("MyGood", workbook.getStyles().get("Good")); myGood.getFont().setBold(true); myGood.getFont().setItalic(true); worksheet.getRange("B1").setStyle(workbook.getStyles().get("MyGood")); worksheet.getRange("B1").setValue("MyGood"); //save to an excel file workbook.save("CreateStyleBaseOn.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("A1").style = workbook.styles.get("Good") worksheet.getRange("A1").value = "Good" // Create and modify a style based on current existing style val myGood = workbook.styles.add("MyGood", workbook.styles.get("Good")) myGood.font.bold = true myGood.font.italic = true worksheet.getRange("B1").style = workbook.styles.get("MyGood") worksheet.getRange("B1").value = "MyGood" //save to an excel file workbook.save("CreateStyleBaseOn.xlsx")