Excel Automation along with web data entry

Help StudioX
,
1

I am trying to make a bot that will fill data that’s being fetched from excel and fill in the data on the website. I want to know if it’s possible to let users decide which excel they want to pick so I created an input dialog box for them to put the ‘copy as a path’ for any excel they want to use.
I have a problem understanding what should I implement for the bot to analyze the data in excel in the correct order. Lastly, I want to know even if I let the user pick the excel sheet how will the bot automatically take inputs in ‘For each excel row’.

2

Hey @sonam1
1.Use Select file activity of Uipath, Filter File Type as Excel, It will let user select the Excel file he wants.
2.Pass Output variable of Select file Acivity in Read Range File Path input.
3.Pass Output variable of read range into For each row DT.

Let me know if you have any Query.

Regards,
Saloni

3

Hi Saloni,
Thank you so much for your suggestion. It worked for me.

Regards,
Sonam

4

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