Set Row Height

The following example shows you how to set worksheet's default row height and custom row height for specific row.

C# example

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

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Worksheet sheet1 = new Worksheet();
            sheet1.DefaultRowHeight = 15;

            Row row1 = new Row();

            row1.Height = 45;
            row1.HasCustomHeight = true;

            sheet1.Rows.Add(row1);

            Workbook book = new Workbook();
            book.Sheets.Add(sheet1);

            book.Save("c:\\test\\output.xlsx", true);
        }
    }
}

VB example

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

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

        Dim sheet1 As New Worksheet()
        sheet1.DefaultRowHeight = 15

        Dim row1 As New Row()

        row1.Height = 45
        row1.HasCustomHeight = True

        sheet1.Rows.Add(row1)

        Dim book As New Workbook()
        book.Sheets.Add(sheet1)

        book.Save("c:\test\output.xlsx", True)

    End Sub
End Module

Independentsoft - any library, any programming language

Spreadsheet .NET > Tutorial > Set Row Height

Need help? Ask our developers: