Read and Write Data In Excel

Help Studio
1

Hi, can someone help me

image

Requirements/condition
If column B is Empty field

  • Bot must get email from Column A

If Column B Contains Data

  • bot Must Skip the item and proceed to the next ROW
2

Hi @Vincent_Nuestro
try this way

  1. Read the excel file and store in dt1 datatable variable

  2. use for each row to loop through each row of dt1

iniside the for each row do the following :

use if condition with condition as row(“Column B”).ToString is Nothing

if the condition is true , in then section use the below assign activity to extrcat the email from column A

email = row(“Column A”).ToString

else, if the condition is false
in else section , use continue activity to skip the current row

Hope the information helps you

Regards,

Nived N
Happy Automation

2 Likes