Font styling

The following example shows you how to style cell fonts including name, size, bold, italic, underline and color.

C# example

using System;
using Independentsoft.Office.Spreadsheet;
using Independentsoft.Office.Spreadsheet.Styles;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Worksheet sheet = new Worksheet();

            CellFormat boldFormat = new CellFormat();
            boldFormat.Font = new Font();
            boldFormat.Font.Name = "Arial";
            boldFormat.Font.Size = 14;
            boldFormat.Font.Bold = true;

            Cell a1 = new Cell("Bold Arial 14");
            a1.Format = boldFormat;
            sheet["A1"] = a1;

            CellFormat italicFormat = new CellFormat();
            italicFormat.Font = new Font();
            italicFormat.Font.Name = "Calibri";
            italicFormat.Font.Size = 12;
            italicFormat.Font.Italic = true;

            Cell a2 = new Cell("Italic Calibri 12");
            a2.Format = italicFormat;
            sheet["A2"] = a2;

            CellFormat colorFormat = new CellFormat();
            colorFormat.Font = new Font();
            colorFormat.Font.Name = "Times New Roman";
            colorFormat.Font.Size = 11;
            colorFormat.Font.Bold = true;
            colorFormat.Font.Color = new DataBarColor();
            colorFormat.Font.Color.Color = "FF0000"; //red

            Cell a3 = new Cell("Red Bold");
            a3.Format = colorFormat;
            sheet["A3"] = a3;

            CellFormat underlineFormat = new CellFormat();
            underlineFormat.Font = new Font();
            underlineFormat.Font.Underline = new Underline(UnderlineType.Single);

            Cell a4 = new Cell("Underlined text");
            a4.Format = underlineFormat;
            sheet["A4"] = a4;

            Workbook book = new Workbook();
            book.Sheets.Add(sheet);
            book.Save("c:\\test\\output.xlsx", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Spreadsheet
Imports Independentsoft.Office.Spreadsheet.Styles

Module Module1
    Sub Main(ByVal args As String())

        Dim sheet As New Worksheet()

        Dim boldFormat As New CellFormat()
        boldFormat.Font = New Font()
        boldFormat.Font.Name = "Arial"
        boldFormat.Font.Size = 14
        boldFormat.Font.Bold = True

        Dim a1 As New Cell("Bold Arial 14")
        a1.Format = boldFormat
        sheet("A1") = a1

        Dim italicFormat As New CellFormat()
        italicFormat.Font = New Font()
        italicFormat.Font.Name = "Calibri"
        italicFormat.Font.Size = 12
        italicFormat.Font.Italic = True

        Dim a2 As New Cell("Italic Calibri 12")
        a2.Format = italicFormat
        sheet("A2") = a2

        Dim colorFormat As New CellFormat()
        colorFormat.Font = New Font()
        colorFormat.Font.Name = "Times New Roman"
        colorFormat.Font.Size = 11
        colorFormat.Font.Bold = True
        colorFormat.Font.Color = New DataBarColor()
        colorFormat.Font.Color.Color = "FF0000" 'red

        Dim a3 As New Cell("Red Bold")
        a3.Format = colorFormat
        sheet("A3") = a3

        Dim book As New Workbook()
        book.Sheets.Add(sheet)
        book.Save("c:\test\output.xlsx", True)

    End Sub
End Module

IndependentsoftProfessional software libraries for developers

Spreadsheet .NET > Tutorial > Font styling

Need help? Ask our developers: