Font styling

The following example shows you how to style cell fonts including name, size, bold, italic, underline and color.
import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.DataBarColor;
import com.independentsoft.office.spreadsheet.Font;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;
import com.independentsoft.office.spreadsheet.styles.CellFormat;
import com.independentsoft.office.spreadsheet.Underline;
import com.independentsoft.office.spreadsheet.UnderlineType;

public class Example {

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

            Font boldFont = new Font();
            boldFont.setName("Arial");
            boldFont.setSize(14);
            boldFont.setBold(true);

            CellFormat boldFormat = new CellFormat();
            boldFormat.setFont(boldFont);

            Cell a1 = new Cell("Bold Arial 14");
            a1.setFormat(boldFormat);
            sheet.set("A1", a1);

            Font italicFont = new Font();
            italicFont.setName("Calibri");
            italicFont.setSize(12);
            italicFont.setItalic(true);

            CellFormat italicFormat = new CellFormat();
            italicFormat.setFont(italicFont);

            Cell a2 = new Cell("Italic Calibri 12");
            a2.setFormat(italicFormat);
            sheet.set("A2", a2);

            DataBarColor redColor = new DataBarColor();
            redColor.setColor("FF0000"); //red

            Font colorFont = new Font();
            colorFont.setName("Times New Roman");
            colorFont.setSize(11);
            colorFont.setBold(true);
            colorFont.setColor(redColor);

            CellFormat colorFormat = new CellFormat();
            colorFormat.setFont(colorFont);

            Cell a3 = new Cell("Red Bold");
            a3.setFormat(colorFormat);
            sheet.set("A3", a3);

            Font underlineFont = new Font();
            underlineFont.setUnderline(new Underline(UnderlineType.SINGLE));

            CellFormat underlineFormat = new CellFormat();
            underlineFormat.setFont(underlineFont);

            Cell a4 = new Cell("Underlined text");
            a4.setFormat(underlineFormat);
            sheet.set("A4", a4);

            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 > Font styling

Need help? Ask our developers:
