Read and Write to excel


#1

Hi,
I have an excel file with 2 columns namely ‘Number’ and ‘Status’(PFA). The status can be ‘Y’ or ‘N’.
Now, depending on the status, I need to read the number from the column named ‘Number’.
If the status is ‘N’ copy the number corresponding to the status, paste it to some
location and set the status to ‘Y’.
If the status is ‘Y’ go to the next row to check the status and the process continues until we find a number with status ‘N’.

Can anybody help me with the logic here?

Number_Status.xlsx (9.7 KB)


#2

hi,
Step 1: first read the excel file and name the variable
Step 2 : take for each row activity pass the dt value
step 3: take 2 assign activity say Number=row.Item(0).toString and Status =row.Item(1).tostring
Step 4 : Take if activity give the condition as Status.tostring=“N” then save to the another variable
Step 5 : pass that variable to the write range
hope this will help :slight_smile:
fyi


#3

Hello @patil.gandhali58

See example attachement

Number_Status.xlsx (10.3 KB)
testStatus.xaml (14.3 KB)


#4

Thank you…


#5