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

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

Cint(Row(1).Tostring)<=40

First check is Row(1)/Tostring having nos or not

There is number

how i can check that ?

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

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

@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

1 Like

Thank you i will try do that

1 Like

Thank you so much SenzoD , It is work

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