Skip to content

Instantly share code, notes, and snippets.

@fileformat-cells-gists
Created August 28, 2024 10:34
Show Gist options
  • Save fileformat-cells-gists/3c3a0db1cc77a5e46c3d0807794bfbc9 to your computer and use it in GitHub Desktop.
Save fileformat-cells-gists/3c3a0db1cc77a5e46c3d0807794bfbc9 to your computer and use it in GitHub Desktop.
This C# example showcases how to get List of Hidden Sheets a MS Excel Spreadsheet in C# using FileFormat.Cells SDK
using FileFormat.Cells
string filePath = "Z:\\Downloads\\hidden_sheets.xlsx";
using (Workbook wb = new Workbook(filePath))
{
List<Tuple<string, string>> hiddenSheets = wb.GetHiddenSheets();
foreach (var sheet in hiddenSheets)
{
Console.WriteLine($"Hidden Sheet ID: {sheet.Item1}, Name: {sheet.Item2}");
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment