Add column to datatable

Help Activities
, , ,
1

i have a website Swag Labs (saucedemo.com). I have an excel file. I am using UiPath version 20.10.8.
I want to load excel file data into datatable and fetch username and password and login into website. Then I want to add a REMARK column in the same excel file same sheet. If login successful then i want to enter LOGIN SUCCESSFUL message in Remark column and if login fails then copy the error message and paste it into remark column.

Plz someone help with the code …
Test 01.xlsx (9.3 KB)
website Swag Labs (saucedemo.com).

2

Add data column to Datatable be used and then use assign activity to write value to column for each row.
501556.xaml (21.5 KB)

3

@Omkar_Shete1

Follow these steps

  1. Use for each row in excel
  2. Open the website using us application/browser…
  3. Inside the loop get the username and password from respective columns using currentrow("columnname").Tostring
  4. Use element exists /chwck app state and check for the login success
  5. If successful update the status column using write cell or update using currentrow("columnnmae")="successful"

Cheers

4

hello Anil, I am using older version of UiPath 20.10.2 So in this I am not able to find activity like For each excel row or Use Excel Process scope

5

Thanks for the solution.

6

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