Write in next column's cell if previous column has empty rows

Help Studio
, ,
1

I have this file. I have to check in the “organisation” column if it is empty or not.If the cell in this column is empty, i have to write “software engineer” in “Occupation” column just beside the empty cell in organisation column. how to do?
testFile.xlsx (6.0 KB)

2

I am also attaching how it should be written if i am unable to express well then.
testFile.xlsx (9.5 KB)

3

Try this BOT file, let me know what you think.
Read and Write in Excel.zip (4.3 KB)

1 Like
4

Thankss.But is there any shorter way.mit is too much confusing

5

Hi @ydash999

You can try this simpler approach

image
image511×575 14.5 KB

WriteInNextColumnCell.xaml (6.6 KB)

1 Like
6

Thanks! How to make it dynamic if in some place I have to write software engineer and in some place I have to write compliance engineer.

7

@ydash999

Make a string variable

Assign it accordingly

and use this variable to assign Row(“Occupation”)

Refer the xaml

WriteInNextColumnCell.xaml (7.0 KB)

Note: you can also convert this variable to argument so that whenever this file is invoked you can pass the required string.

1 Like
8

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