GroupDocsGists
10/19/2017 - 11:19 AM

RemoveHiddenDataInExcel.cs

// 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.");