// For complete examples and data files, please go to https://github.com/groupdocs-metadata/GroupDocs.Metadata-for-.NET
// initialize XlsFormat
XlsFormat xlsFormat = new XlsFormat(Common.MapSourceFilePath(filePath));
// get hidden data
XlsInspectionResult hiddenData = xlsFormat.InspectDocument();
// get hidden sheets
XlsSheet[] hiddenSheets = hiddenData.HiddenSheets;
// display hidden fields
if (hiddenSheets.Length > 0)
{
// 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.");