Cell alignment

The following example shows you how to set cell alignment including horizontal, vertical, text wrap, rotation and indent.

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 centerFormat = new CellFormat();
            centerFormat.Alignment = new CellAlignment();
            centerFormat.Alignment.HorizontalAlignment = HorizontalAlignment.Center;
            centerFormat.Alignment.VerticalAlignment = VerticalAlignment.Top;
            centerFormat.ApplyAlignment = true;

            Cell a1 = new Cell("Center + Top");
            a1.Format = centerFormat;
            sheet["A1"] = a1;

            CellFormat wrapFormat = new CellFormat();
            wrapFormat.Alignment = new CellAlignment();
            wrapFormat.Alignment.WrapText = true;
            wrapFormat.Alignment.HorizontalAlignment = HorizontalAlignment.Left;
            wrapFormat.ApplyAlignment = true;

            Cell b1 = new Cell("This is a long text that will wrap inside the cell");
            b1.Format = wrapFormat;
            sheet["B1"] = b1;

            CellFormat rotateFormat = new CellFormat();
            rotateFormat.Alignment = new CellAlignment();
            rotateFormat.Alignment.TextRotation = 45;
            rotateFormat.Alignment.HorizontalAlignment = HorizontalAlignment.Center;
            rotateFormat.ApplyAlignment = true;

            Cell c1 = new Cell("Rotated 45");
            c1.Format = rotateFormat;
            sheet["C1"] = c1;

            CellFormat indentFormat = new CellFormat();
            indentFormat.Alignment = new CellAlignment();
            indentFormat.Alignment.Indent = 3;
            indentFormat.ApplyAlignment = true;

            Cell a2 = new Cell("Indented text");
            a2.Format = indentFormat;
            sheet["A2"] = a2;

            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 centerFormat As New CellFormat()
        centerFormat.Alignment = New CellAlignment()
        centerFormat.Alignment.HorizontalAlignment = HorizontalAlignment.Center
        centerFormat.Alignment.VerticalAlignment = VerticalAlignment.Top
        centerFormat.ApplyAlignment = True

        Dim a1 As New Cell("Center + Top")
        a1.Format = centerFormat
        sheet("A1") = a1

        Dim wrapFormat As New CellFormat()
        wrapFormat.Alignment = New CellAlignment()
        wrapFormat.Alignment.WrapText = True
        wrapFormat.Alignment.HorizontalAlignment = HorizontalAlignment.Left
        wrapFormat.ApplyAlignment = True

        Dim b1 As New Cell("This is a long text that will wrap inside the cell")
        b1.Format = wrapFormat
        sheet("B1") = b1

        Dim rotateFormat As New CellFormat()
        rotateFormat.Alignment = New CellAlignment()
        rotateFormat.Alignment.TextRotation = 45
        rotateFormat.Alignment.HorizontalAlignment = HorizontalAlignment.Center
        rotateFormat.ApplyAlignment = True

        Dim c1 As New Cell("Rotated 45")
        c1.Format = rotateFormat
        sheet("C1") = c1

        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 > Cell alignment

Need help? Ask our developers: