//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IRange b2 = worksheet.getRange("B2"); ITextRun run1 = b2.getRichText().add("GrapeCity"); run1.getFont().setName("Agency FB"); run1.getFont().setSize(26); run1.getFont().setThemeColor(ThemeColor.Accent1); run1.getFont().setBold(true); ITextRun run2 = b2.getRichText().add(" Documents"); run2.getFont().setThemeColor(ThemeColor.Accent2); run2.getFont().setName("Arial Black"); run2.getFont().setSize(20); run2.getFont().setUnderline(UnderlineType.Single); ITextRun run3 = b2.getRichText().add(" for "); run3.getFont().setItalic(true); ITextRun run4 = b2.getRichText().add("Excel"); run4.getFont().setColor(Color.GetBlue()); run4.getFont().setBold(true); run4.getFont().setSize(26); run4.getFont().setUnderline(UnderlineType.Double); b2.getEntireRow().setRowHeight(42); //save to an excel file workbook.save("AddTextRun.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val b2 = worksheet.getRange("B2") val run1 = b2.richText.add("GrapeCity") run1.font.name = "Agency FB" run1.font.size = 26.0 run1.font.themeColor = ThemeColor.Accent1 run1.font.bold = true val run2 = b2.richText.add(" Documents") run2.font.themeColor = ThemeColor.Accent2 run2.font.name = "Arial Black" run2.font.size = 20.0 run2.font.underline = UnderlineType.Single val run3 = b2.richText.add(" for ") run3.font.italic = true val run4 = b2.richText.add("Excel") run4.font.color = Color.GetBlue() run4.font.bold = true run4.font.size = 26.0 run4.font.underline = UnderlineType.Double b2.entireRow.rowHeight = 42.0 //save to an excel file workbook.save("AddTextRun.xlsx")