Read and Write Data In Excel

Hi, can someone help me


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

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


Nived N
Happy Automation