The sample demonstrates how to set row height in Excel workbook via Spire.XLS.

using Spire.Xls;

namespace SetRowHeight
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\..\..\Data\parts.xls");
            Worksheet sheet = workbook.Worksheets[0];
            
            //set the RowHeight=25 of the first row
            sheet.SetRowHeight(1, 25);

            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports Spire.Xls

Namespace SetRowHeight
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			Dim workbook As New Workbook()
			workbook.LoadFromFile("..\..\..\..\Data\parts.xls")
			Dim sheet As Worksheet = workbook.Worksheets(0)

			'set the RowHeight=25 of the first row
			sheet.SetRowHeight(1, 25)

			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class
End Namespace

The sample demonstrates how to hide worksheet row in Excel workbook via Spire.XLS.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using Spire.Xls;

namespace RowHide
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\..\..\Data\parts.xls");
            Worksheet sheet = workbook.Worksheets[0];

            //hide the fourth row of sheet
            sheet.HideRow(4);

            //hide the seventh row of sheet
            sheet.HideRow(7);

            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Linq
Imports System.Text

Imports Spire.Xls

Namespace RowHide
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			Dim workbook As New Workbook()
			workbook.LoadFromFile("..\..\..\..\Data\parts.xls")
			Dim sheet As Worksheet = workbook.Worksheets(0)

			'hide the fourth row of sheet
			sheet.HideRow(4)

			'hide the seventh row of sheet
			sheet.HideRow(7)

			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class
End Namespace

The sample demonstrates how to hide worksheet column in Excel workbook via Spire.XLS.

using Spire.Xls;

namespace HideColumn
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\..\..\Data\vendors.xls");
            Worksheet sheet = workbook.Worksheets[0];
            
            //hide the first column  of sheet
            sheet.HideColumn(1);

           //hide the sixth column of sheet
            sheet.HideColumn(6);
            
            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports Spire.Xls

Namespace HideColumn
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			Dim workbook As New Workbook()
			workbook.LoadFromFile("..\..\..\..\Data\vendors.xls")
			Dim sheet As Worksheet = workbook.Worksheets(0)

			'hide the first column  of sheet
			sheet.HideColumn(1)

		   'hide the sixth column of sheet
			sheet.HideColumn(6)

			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class
End Namespace