Filter Hidden Text in Microsoft Excel Files

Normally, Filter does not filter hidden text from a Microsoft Excel spreadsheet because it is assumed the text should not be exposed. You can change this default behavior, and extract text from hidden rows, columns, and sheets from Excel spreadsheets by adding the following lines to the formats.ini file:

[Options]
gethiddeninfo=1

NOTE: You can also set an API flag to filter text from hidden sheets. See Hidden Data in Microsoft Excel Documents for more information.