Rich text in cells

The following example shows you how to create cells with rich inline text where different runs have different formatting such as bold, italic and color.

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.DataBarColor;
import com.independentsoft.office.spreadsheet.RichTextInline;
import com.independentsoft.office.spreadsheet.Run;
import com.independentsoft.office.spreadsheet.RunVerticalAlignment;
import com.independentsoft.office.spreadsheet.Text;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Worksheet sheet = new Worksheet();

            Run run1 = new Run();
            run1.setText(new Text("Hello ", true));
            run1.setBold(true);
            run1.setFont("Arial");
            run1.setSize(12);

            Run run2 = new Run();
            run2.setText(new Text("World", false));
            run2.setFont("Arial");
            run2.setSize(12);

            Run run3 = new Run();
            run3.setText(new Text(" (formatted)", true));
            run3.setItalic(true);
            run3.setFont("Arial");
            run3.setSize(12);
            DataBarColor blue = new DataBarColor();
            blue.setColor("0000FF");
            run3.setColor(blue);

            RichTextInline richText = new RichTextInline();
            richText.getRuns().add(run1);
            richText.getRuns().add(run2);
            richText.getRuns().add(run3);

            Cell cell1 = new Cell();
            cell1.setRichTextInline(richText);
            sheet.set("A1", cell1);

            Run normal = new Run();
            normal.setText(new Text("H", false));

            Run superRun = new Run();
            superRun.setText(new Text("2", false));
            superRun.setRunVerticalAlignment(RunVerticalAlignment.SUPERSCRIPT);
            superRun.setSize(8);

            Run normalEnd = new Run();
            normalEnd.setText(new Text("O", false));

            RichTextInline formula = new RichTextInline();
            formula.getRuns().add(normal);
            formula.getRuns().add(superRun);
            formula.getRuns().add(normalEnd);

            Cell cell2 = new Cell();
            cell2.setRichTextInline(formula);
            sheet.set("A2", cell2);

            Workbook book = new Workbook();
            book.getSheets().add(sheet);
            book.save("c:\\test\\output.xlsx", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Rich text in cells

Need help? Ask our developers: