If Conduction

[coder]

Hi all ,

it try to add the data from excel to queue and only i need number which are <= 40

If: Conversion from type ‘DBNull’ to type ‘Integer’ is not valid.

but i get this error how i can solve that ?

Thank you

[ImPratham45 (Prathamesh Patil)]

Cint(Row(1).Tostring)<=40
First check is Row(1)/Tostring having nos or not

[coder]

There is number

[coder]

how i can check that ?

[SenzoD (Senzo Dlomo)]

This is incorrect, you cannot compare strings against integers, and again strings are compared using the .Eqauls() or .Contains() method.

[coder]

Hi SenzoD i know where is the error there are some empty cell so it is give the error .

how i can delete the empty row which has empty cell ?

if i have 2 columns name price and the cell of price is empty

[SenzoD (Senzo Dlomo)]

@coder, since you are adding to the queue you do not necessarily need to delete the empty ones but just leave them. You can create another if activity and drag your current one into the then part, try the below expression on your outside if, so now if the value is null or empty it should go to the else part

Not String.IsNullOrEmpty(row(1).ToString)

And this is assuming you are using a for each row activity

[coder]

Thank you i will try do that

[coder]

Thank you so much SenzoD , It is work

[SenzoD (Senzo Dlomo)]

@coder, glad i could help.