Scenario: I am using a read range activity inside the application scope to get all data from a specific sheet into a datatable. I am finding that if the document was saved by the user with the filters still active then when my workflow runs it ignores these rows, so in my case I have 270 rows of data but my datatable only contained 240, the excel document was filter and was showing the missing 30 rows. As soon as I removed these filters from the document and saved the workflow was able to save all 270 rows into the datatable
Steps to reproduce: Filter an excel sheet
Current Behavior:
Expected Behavior:
Studio/Robot/Orchestrator Version: Ui Path Studio Pro - v2016.2.6274
Last stable behavior:
Last stable version:
OS Version: Windows Server 2012
Others if Relevant: (workflow, logs, .net version, service pack, etc):