This is my first time writing in a forum, please bear with me for lengthy note.
I have an excel containing 272 rows of which I need to apply a filter based on specific key words. I tried using “datatable.select” function which works fine up to 256 rows and for the 257 row UIPATH throws an error message as follows.
Assign : Min (257) must be less than or equal to max (-1) in a Range object.
Believe the issue with UIPATH is that, it doesn’t recognize rows ranges from 257 if any of the cell under particular column which is being filtered contains special character. (Ex: '0041).
I re-ran the studio by removing those cells having quotes and it works fine this time.
If this is going to be an issue then it affects our entire process.
Can somebody help me with an alternate way of filtering the datatable. Thanks in advance!!