How To Find If The Excel File XLSB Has Hidden Data

News Knowledge Base
1

How to find if the Excel file(XLSB) has hidden data?

Issue Description

Possible Scenarios:

  • When trying to use the Append range/Write range activity, the data is appended after a few blank rows.
  • When deleting the Blank rows and trying to append the data, the data is appended as expected.
  • Getting the incorrect row count of the Excel file.

Resolution

  • Copy the entire data from the Excel to a CSV file and open it in Notepad++, there are some empty cells available in the sheet.

Example:

  • When using the append range activities the data will be populated after 256638