Error #N/A is not a valid value for Int32

I want to read cell H6 (highlight yellow)
In cell H6 sometime show #N/A or number.

But show error Read Cell: #N/A is not a valid value for Int32.

image

Please guide me about it.

@fairymemay

As you said H6 has valid value and some time invalid value

You can use Try catch activity and place Read cell activity

Hope this may help you

Thanks

@Srini84
How to set try catch?
image

@fairymemay

Can you tell me what you want to do after Read Cell activity also what type of exception you are getting in the error

That you have to select in Catches and give your activities you want to do when exception hits in that block

Hope this may help you

Thanks

@Srini84 After read cell I want to check data in H6 , if data = #N/A write line
If data not = #N/A —> send data to sequence as below.

@fairymemay

Try as below

First get the exception type you are getting in Read Cell

Surrond Read Cell with Try Catch, In Try Declare a variable as below

In Catches select the exception and place as below

Now use If condition as below If exception hit or not

Hope this may help you

Thanks

@Srini84 same error.

My file excel : data11.xlsx (8.5 KB)

@fairymemay

check the exception type as below

You need to make catches with the same exception and place your assign activity as below

Catch->New->Browse for Types->Search for NotsupportedException

Hope this may help you

@Srini84 same error.
image

Output read cell —> int variable.

Please guide me more for solve it.

Try changing variable data type from “Int32” to “Generic value” for Read cell output value.

1 Like

@sshubham.agrawal93 I can’t change to Generic value.
Because If I change variable rows to another type (except int) it show popup as below.

image

I was talking about changing data type of the variable used in “Read Cell” Activity.

@sshubham.agrawal93 yes , I understand you.
Change data type variable in output read cell.
But I use same variable in next step. (It want type int only)

If I change to Generic value It error in next step.

in the next step, you can convert the same variable to int32 using below syntax.
Convert.toInt32(“Generic Value variable”)

@sshubham.agrawal93 Error : Assign: Input string was not in a correct format.

image

My file excel :
data11.xlsx (8.5 KB)

I want to read cell H6

If output = #N/A write line
If data not = #N/A —> send data to sequence as below.

Hi,

The flow should go like this:

1.Read cell (in generic value variable)
2. Check If extracted value = “#N/A”
3. If not then convert.Int32(variable name) (do not use double quotes with the variable name) remove double quotes
4. click img

Hi @fairymemay !
What about using the other read cell with generic value ?


Here is a suggestion: Go_over_NA.xaml (6.6 KB)

Let us know if it does not work as expected :grinning_face_with_smiling_eyes:

@sshubham.agrawal93 Error convert to int as below.

Please guide me for solve it.

Hi @fairymemay

Please try this if it works,

Cint(rows.tostring.trim)

Or

Convert.toint32(rows.tostring.trim)

Thanks

1 Like

@fairymemay

You are debugging the workflow, Debug always stops in error even if surrounded by try catch, try to run the workflow and you will see catch is executed

Hope this may help you

Thanks

2 Likes