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
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 theRead Row activity
which gives the cell values of that row
Output