Find Hidden Worksheet

The following example shows you how to find hidden worksheet .

C# example

using System;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            foreach(Worksheet sheet in book.Sheets)
            {
                if(sheet.VisibilityState == SheetVisibilityType.Hidden)
                {
                    Console.WriteLine("Hidden sheet: " + sheet.Name);
                }
            }

            Console.Read();
        }
    }
}

VB example

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

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

        Dim book As New Workbook("c:\test\input.xlsx")

        For Each sheet As Worksheet In book.Sheets
            If sheet.VisibilityState = SheetVisibilityType.Hidden Then
                Console.WriteLine("Hidden sheet: " + sheet.Name)
            End If
        Next

        Console.Read()

    End Sub
End Module

Independentsoft - any library, any programming language

Spreadsheet .NET > Tutorial > Find Hidden Worksheet

Need help? Ask our developers: