Stuck in process Flow

Help Activities
1

Stuck at Write Range Activity during Process Flow, defined Workbook Variable but still unable to proceed forward. following is the process flow

I have a list of Customer detail in Excel File (“C:\Users\muhammad.azam\Downloads\challenge.xlsx”) . I want to copy the CNIC mentioned in Column D with header “CNIC” and paste it on the website (https://nfs.punjab.gov.pk/) in CNIC field, then Click “Search” button. The website will give me result, Now, the result is to be copied against each Cnic in Column H with header “OCRResult”. Secondly, when the result appear, process should also take snap shot of the result screen, and save it in a a folder (C:\Users\muhammad.azam\Downloads\NACTA Screening Snap Shots\Test Two -Screenshot). the file name will be CNIC so that i can identify the file easily. There are around 6000 customer, so i want to create a loop process. That is why i want to deply RPA.

2
  1. Read the spreadsheet
  2. For each row in the data table
    1. , get the row(cnic)
    2. Use the application browser u needed
    3. paste the row value into the desired field
    4. Get the result using get text
    5. Assign the result into the row(column name )
    6. For taking screen shot , you have a take screenshot shot activity , give the folder path to save the image
3

@Muhammad_Azam

  1. Use excel file → for each row in excel
  2. Inside lop perform ur steps and use currentrow("CNIC").ToString will give required value
  3. Use assign currentrow("ColumnToUpdate") = "value to update"

Cheers