Hey Everyone,
I am trying to create a UiPath Bot that can read the student id from one excel sheet (google spreadsheet) which also has a column for total attendance and automatically searches all corresponding attendance of that student in another sheet through student id and constantly add the total attendance keeping it updated in the first sheet. So how can i implement this ?
Hi @spsp2305
Here are some steps you can follow
1.Read the google sheet 1 and stored into dt1
2.For each row data in dt1
3.inside for each use assign activity studentID = row(“StudentID”).ToString
4.read second sheet and stored into dt2 from Google Sheet 2.
5.use linq to get match student id
attendanceSum = dt2.AsEnumerable().Where(Function(row) row(“StudentID”).ToString = currentStudentID).Sum(Function(row) Convert.ToInt32(row(“Attendance”)))
6.use write cell activity to update the attendance