usmanazizgroupdocs
8/17/2016 - 2:19 PM

GetHiddenDataInExcel.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;

// get comments
XlsComment[] comments = hiddenData.Comments;

if (comments.Length > 0)
{
    foreach (XlsComment comment in comments)
    {
        Console.WriteLine("Comment: {0}, Column: {1}", comment.ToString(), comment.Column);
    }
}
else
{
    Console.WriteLine("No comment found!");
}