Excel Auto

How to Read the Dynamic Row in Excel File ? Explain ?

hey

can you explain better, if possible an example?

regards!

@AsadPathan2665 You mean how to read the row dynamically in excel file. If that is the case there were two approaches. Please find workflow for the below approaches

Example.zip (11.4 KB)

Approach 1

  • If you know which row you want to retrieve you can use Read Row activity within excel scope
  • Loop through the output to get the each cell value of that row

Input

Capture

Output

Approach 2

  • if you want to get the row, based on a specific cell value then you can look for that value using Lookup range activity. Once you find in which row that value is present, you can pass the row value again to the Read Row activity which gives the cell values of that row

Output