Check row is empty or not in excel and update value in another sheet of excel

Learning & Development Programs Automation Starter
, , , ,
1

Hi All,

Book1 test.xlsx (9.2 KB)
This is my sample excel, if row B is blank it should fetch the row C and write in another sheet say sheet2 excel file.
image
Need to consider the blanks and update the Column order in another excel.
Sample file has been attached, please look on it.
How to do this, please help me.

Thanks,
Lakshmi

2

Which is the output you want ?

Pls take screenshot or send the sample file.

3

@Mr.H
image
required output.
Output need to be stored in this sheet.
image
Sample file
Book1 test.xlsx (9.2 KB)
Please look on it.
Regards,
Lakshmi

4

Hi @lakshmi.mp

  1. Read the excel file using Read Range activity Store in Dt Variable
  2. For each row in DataTable activity
  3. If Activity
String.IsNullOrEmpty(CurrentRow("Number").Tostring)

Then Part
You can process your needing here!

Else Part
We have a value in the row in the Number column

Regards
Gokul

1 Like
5

Pls check sample
File.zip (68.9 KB)

1 Like
6

@Mr.H and @Gokul001 ,

Thanks a lot for helping and providing solution. Able to fetch the data.
Thank you.

Regards,
Lakshmi

7

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