//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IRange a1 = worksheet.getRange("A1"); a1.getFont().setSize(18); a1.getFont().setBold(true); a1.setVerticalAlignment(VerticalAlignment.Center); a1.getEntireRow().setRowHeight(42); a1.getEntireColumn().setColumnWidth(35); a1.setValue("Perfect square trinomial"); ITextRun run = a1.characters(8, 7); run.getFont().setItalic(true); run.getFont().setThemeColor(ThemeColor.Accent1); IRange b1 = worksheet.getRange("B1"); b1.getFont().setSize(26); b1.getEntireColumn().setColumnWidth(40); b1.setValue("(a+b)2 = a2+2ab+b2"); ITextRun superRun1 = b1.characters(5, 1); superRun1.getFont().setSuperscript(true); superRun1.getFont().setColor(Color.GetRed()); ITextRun superRun2 = b1.characters(10, 1); superRun2.getFont().setSuperscript(true); superRun2.getFont().setColor(Color.GetGreen()); ITextRun superRun3 = b1.characters(17, 1); superRun3.getFont().setSuperscript(true); superRun3.getFont().setColor(Color.GetBlue()); //save to an pdf file workbook.save("ExportCellRichText.pdf");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val a1 = worksheet.getRange("A1") a1.font.size = 18.0 a1.font.bold = true a1.verticalAlignment = VerticalAlignment.Center a1.entireRow.rowHeight = 42.0 a1.entireColumn.columnWidth = 35.0 a1.value = "Perfect square trinomial" val run = a1.characters(8, 7) run.font.italic = true run.font.themeColor = ThemeColor.Accent1 val b1 = worksheet.getRange("B1") b1.font.size = 26.0 b1.entireColumn.columnWidth = 40.0 b1.value = "(a+b)2 = a2+2ab+b2" val superRun1 = b1.characters(5, 1) superRun1.font.superscript = true superRun1.font.color = Color.GetRed() val superRun2 = b1.characters(10, 1) superRun2.font.superscript = true superRun2.font.color = Color.GetGreen() val superRun3 = b1.characters(17, 1) superRun3.font.superscript = true superRun3.font.color = Color.GetBlue() //save to an pdf file workbook.save("ExportCellRichText.pdf")