How to Read the Dynamic Row in Excel File ? Explain ?
can you explain better, if possible an example?
@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)
- 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
- 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 activitywhich gives the cell values of that row