How to take action base on whether the specific excel cell is null or not?

Help Activities
1

Dear Experts

I have a request as below, can you have give me some guidance about how to do it:

  • I need to fill in a website form base on the specific detail in a excel file one by one
  • If the specifi excel cell is null, then no need to input corresponding box in the website form
  • If the specifi excel cell is not null, then replace the original content in the website box with the excel cell detail

Example:

  • Excel column [Latest Financial Year Total Revenue] is null, then no need to change the website box content(which is “0” in below screenshot)
  • Excel column [Latest Finanacial Year Total Capital] is not null, then replace the original website box content(“8,000,000”) with the excel cell detail(“10,000,000”)

image
image854Ă—560 60.6 KB

Thank you for your advise in advance

Ivan

2

@yangyq10

You can use read cell to read the data into a variable make sure you keep the variable datatype as GenericValue…

Then after read cell use if condition with IsNothing(variable) OrElse String.IsNullOrEmpty(variable.ToString) …on then side it is null so do nothing and on else side it is not so write the data to required field you need using ui activities like type into and pass variable.ToString as in put

Cheers

3

@Anil_G Thank you, can you help take a look if I am doing it right as below?

image
image499Ă—742 28.8 KB

image
image507Ă—233 7.24 KB

image
image471Ă—210 8.13 KB

4

@yangyq10

Then condition looks correct …hope you selected or instead of and

But it would be better if you open advanced editor and write orelse instead of or…

Cheers

5

I just try to run it but there is some error on IF, can you help take a look?

image
image

6

@yangyq10

Did you use orelse only?

or did you use OR?

cheers

7

@Anil_G There are only 2 options in IF. I use Any(OR)

image

8

@yangyq10

as mentioned earlier…click on plus and open advanced editor and in place of or write orelse

cheers

9

@Anil_G Thank you for the reminder. It should be working now. Let me test another round on it

image

1 Like
10

@Anil_G

I am sorry that I have one more question for enhancement

Its possible that there is space in the blank filed. So I need to use [replace] to remove spaces

But it keep popping up error message

May I know how I should set it right?

image

image
image

image

Thanks

11

Hey @yangyq10 ,

You can check using

String.isnullorwhitespace(“yourstringvariable”)

Above will return true if it is empty space false if not

12

@yangyq10 try using .Trim instead of replace

Cheers

13

@Anil_G But Trim is only used for remove spaces at the beginning and end of a filed. Is it suitable in my scenario?

14

@yangyq10

So in the string where you have spaces you want to remove? or if only space is there you want to remove?

Also before replace try to check if the string is empty or not

cheers

15

@Anil_G There will be no string in such “empty fileds”. I just need to make sure there are no spaces in it while it looks like “empty”. Because it will recover the orignial data in the website form with spaces which will cause problems in business. All I need is to keep website form no change when the relative excel filed is completely null/empty(without spaces)

image

16

@yangyq10

then just use variablename.trim

cheers

17

@Anil_G

Below steps are what I revise just now, can you help take a look if any issue?

  1. If len>0, if yes, then assign A1 = A.trim
    image
    image
    image

  2. If A1 is empty or null. If no, then input information(A) in website

    image
    image729Ă—371 14.2 KB

18

@yangyq10

instead of length >0 use Not IsNothing(Variable)

cheers

19

@Anil_G

I face a issue today when I further debug
There is actully some value in my excel column
However, after I ran below activities, the output message is True(which means the activities consider no vaule in my excel column)
Do you have any idea why this issue happen?

image

image
image503Ă—757 24.7 KB

image

image

image

image

image

image

Thanks
Ivan

20

@yangyq10

Can you print the actual value and check if it is reqding as expected and also if it is reading yhe right cell

Cheers