usmanazizgroupdocs
8/17/2016 - 2:37 PM

GetHiddenDataInExcel.vb

' 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

' get comments
Dim comments As XlsComment() = hiddenData.Comments

If comments.Length > 0 Then
	For Each comment As XlsComment In comments
		Console.WriteLine("Comment: {0}, Column: {1}", comment.ToString(), comment.Column)
	Next
Else
	Console.WriteLine("No comment found!")
End If