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