- Demo
- C# source
- VB.Net source
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
