How can i get the values from the different columns like one or two columns values from the excel instead of using config file because i want to get the values of more than one or two columns of the excel to use in the work flow in the Rpa uipath

How can i get the values from the different columns like one or two columns values from the excel instead of using config file because i want to get the values of more than one or two columns of the excel to use in the work flow in the Rpa UiPath…

Hi @sameer_khan1
Read the excel using read range and store it in datatable and access the data by using datatable variable

You can use Read Range basically to get the value from the spreadsheet and Iterate using For each row in Datatable. Also, we can use the Linq query instead of using the For Each. Hope it answers you questions.

Happy Learning!!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.