How to use read range function to get integer value from excel

[yjkim (Kim Yu Jo)]

Hi there,

I am trying to read a cell in an excel sheet with integer value to do conditional analysis.
However, i keep encountering the error below:
Operator ‘>’ is not defined for type ‘System.Data.DataTable’ and ’ Integer’

Please help!

[aksh1yadav (AKSHAY YADAV)]

@yjkim

I am trying to read a cell in an excel sheet with integer value to do conditional analysis

To read a cell please use **Read Cell ** activity. and pass the column with cell index.

@yjkim

However, i keep encountering the error below:

Operator ‘>’ is not defined for type ‘System.Data.DataTable’ and ’ Integer’

This is because read range will read the range of an excel sheet and it will always return you datatable not a single value.

So you should use Read cell activity instead of Read Range.

Note - After get the data from Read Cell just confirm the data type of that, if it will be Generic then convert that into int then use logical operators on that.

Regards…!!
Aksh

[ddpadil (Dilip)]

Hi,
Have you been through this awesome training yet.
It’s free.
The world’s first open online training platform for RPA users.
https://academy.uipath.com/lms/index.php?r=site/index

Happy Automation
Cheers

[sdame]

@aksh1yadav

After get the data from Read Cell just confirm the data type of that, if

How do you then convert that data to an integer?

[aksh1yadav (AKSHAY YADAV)]

@sdame

How do you then convert that data to an integer?

How to convert GenericValue to Int32

For example, In my flow chart, I have use input dialog to take integer value.Now I want to validate this field with Decision control.If input is numeric than true else false. For that I am checking input with GenericValue and put assign activity to convert value in to Int32. But do not know how to conver it. Can anybody help please?

Regards…!!
Aksh