Open topic with navigation
Normally, Filter does not filter hidden text from a Microsoft Excel spreadsheet because it is assumed that the text should not be exposed. To extract text from hidden rows, columns, and sheets from Excel spreadsheets, add the following lines to the
You can also set an API flag to filter text from hidden sheets. See Hidden Data in Microsoft Excel Documents for more information.