How to update data in already selected Excel file

Leapwork allows user to perform Data driven testing using Excel block, its very easy to add excel file using "Read excel" block, however user must understand below scenarios using which user can update the content of already used excel files.  

1. Scenario 1 : User selects Data File and define a Range 

When user selects a data file option to upload excel and define a Range then the excel file with the data and selected range is stored in Leapwork and the uploaded file will NOT be available for further editing inside Leapwork . 

Solution : In this case user can 1) Re-upload the file with the updated Data and define range again, or 2) User can attach another excel file and drag and drop newly attached file to Read excel block

2. Scenario 2 : User selects Local path and define a Range  

When user selects a Local Path option and define a Range in excel file then the excel file with the data and selected range is always referred from the Local Path in Leapwork and the referred excel file will always be available for further editing of content.

Note: If user update content on already define range then test will run with updated data. In case more row/column have been added to excel file then range should be defined again.

For any clarification, please contact our Priority Support.