Whenever I use any workbook activity like read range , read column , etc. I am getting error as “Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index”.
But , When I used Read range with exact same range parameters within Excel application scope , its working.
Can anybody please help.
Thank you. I have tried copying the data which I need to read in some sample excel. I kept the range same. There it worked. As per my observation , this activity of workbook (Read range , read column , write range) is not working if the excel contains pivots n all. In the regular excel (without pivots) its working on the same data.
I’m a new to UiPath & I began with the “Get Started With RPA Development” course. In the 1st video tutorial I encounter the "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index.
Please see the attached screenshot. I am using the MailMessages(0) index as indicated in the tutorial. Any assistance, will be greatly appreciated.
Apologies for not being available to respond earlier.
Choosing the correct scope for the variable: MailMessages is what ultimately resolved
Make sure the variable naming convention and spelling remain consistent when editing variables in different locations within Studio.
E.g., when creating a variable, the type is automatically generated depending on the selected property and this directly affects the scope. As a result, I found the managing variables link to be very helpful.