Cacher is the code snippet organizer for pro developers

' For complete examples and data files, please go to https://github.com/groupdocs-metadata/GroupDocs.Metadata-for-.NET
' initialize XlsFormat
Dim xlsFormat As New XlsFormat(Common.MapSourceFilePath(filePath))

' get hidden data
Dim hiddenData As XlsInspectionResult = xlsFormat.InspectDocument()

' get hidden sheets
Dim hiddenSheets As XlsSheet() = hiddenData.HiddenSheets

' display hidden fields 
If hiddenSheets.Length > 0 Then
	' clear hidden sheets
	xlsFormat.RemoveHiddenData(New XlsInspectionOptions(XlsInspectorOptionsEnum.HiddenSheets))
	Console.WriteLine("Hidden sheets removed.")

	' and commit changes
	xlsFormat.Save()
	Console.WriteLine("Changes save successfully!")
Else
	Console.WriteLine("No sheets found.")
End If