Message: There is no row at position 100

Learn Academy Feedback
,
1

hi,

i am using data scapping
data have more that 100 rows in grid.

20.4.3

Source: Assign

Message: There is no row at position 100.

Exception Type: System.IndexOutOfRangeException

i am getting error.
i have grid with 165 rows data.

detailed error:

i found an option in data scrapping properties is
but i am unable to edit it. help

image

2

@anilkumar.vegi - Try to set MaxNumberOfResults to 0 (ZERO) and check.

3

Hi @anilkumar.vegi,

You have set max no of results as 100, That is the reason you are getting that error. Set it as 0 to avoid this issue.

Warm Regards,
Ranjith Udayakumar

4

i given 100000 no but now i am getting There is no row at position 52.
if i set 0 value will it fix all this type of issues.

5

@anilkumar.vegi

keep 0 to scrape all the available data

later by doing data table manipulations, you can filter how many records were required for you

Mark as solution if this helps

Thanks

6

Hi @anilkumar.vegi,

Yes, It will. Try and let us know if you face any issues.

Warm Regards,
Ranjith Udayakumar

7

that issue is fixed but later i am appended the exported data into excel sheet
i am facing
Source: Append Range

Message: The process cannot access the file ‘\UiPath\LISA\Mismatch.xlsx’ because it is being used by another process

8

thanks Srinu.
i am getting 20.4.3

Source: Assign

Message: There is no row at position 52.

Exception Type: System.IndexOutOfRangeException

again.

9

@anilkumar.vegi

Can you check the data is correctly scrapped, share your xaml file project json file

Thanks

10

FindingMismatchData.xaml (217.3 KB)

xaml file

11

Hi @anilkumar.vegi,

It will come when the sheet is open. Close the excel before running the bot.

Thanks and Regards,
Ranjith Udayakumar