Help me solve

Help Activities
,
1

How do I loop the excel worksheets tabs and paste the selected
data into google form using uipath ?

2

Hi

Welcome to uipath forum

We can use read and write range activity for this
To navigate across sheets in excel

  1. Use a excel application scope and pass the filepath of excel as input and get the output as out_workbook from the same activity

  2. Inside the scope use a FOR EACH activity and pass input as out_workbook.GetSheets and change the type argument property as String

  3. Inside the loop use a READ RANGE activity and pass sheetname as item and get the output as datatable named as dt

Then you can do the changes you want and write back with write range activity

Cheers @tech1ww

3

Hello @tech1ww

If you want to go through each row from a sheet and to update the google form, you can do as the first screenshot. If you want to loop through each excel sheet and the data inside each sheet, you can refer the 2nd screenshot.

image
image451×700 21.9 KB

image
image487×718 21.8 KB