Read Range Missing Data

excel
activities

#1

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):


#2

Hi Andrew,

Could you please try to update your Excel package to version 2.0.6382.14545 and try again?