In UiPath i am using foreach loop with string. for most of the data system works fine. But for following data I am always getting at the end as :“System Index out of Range Exception”. Data - 0000000 01 0000123.00 0000000 02 0000124.00 0000000 03 0000126.00 …

I don’t have access to computer, we can continue tomorrow after this. Create a datatable with 6 columns. string readText = File.ReadAllLines(“yourfile.txt”); foreach(item in readText) { If (item<> string.empty) { List = Split(item,“,”).Tolist() Check list item count here and if less that 6 a…

Can you share your logic? On what basis are you creating string array? At what point ur getting that error?

Vaidya, Below url contains Xamal i am just reusing it: Notepad to Excel write . Only difference is above url contains 3 columns here i am using 6 columns. So i have changed column names in build data table & in array row i am passing 6 arrays as {array(0),array(1),…}. All the functionalities are work…

Can you validate your array before interesting into Add Data Row for every record array.Length>0 or array.Length=6 if its standard

Added the condition to check array length. Below data is causing the problem : 0000000 07 0000145.00. Instead of 6 arrays we are processing 3 columns but irrespective of count I need to process . even after checking array length I am still facing issues with Index out of range exception…

@SKE i think I did in a complex way, but it works. Please find attached logic (used list instead of array). Let me know if doesn’t help. AddIndex.xaml (7.8 KB)

Vinay list format works . But as per my initial post I have designed the system to accept through arrays - having 6 controls in a row and those were filled by array(0) to array (5) through for each. Now again these list needs to be converted to fixed length arrays (size to 6). for example below dat…

@SKE you are converting each row into list by splitting that row by space delimiter. Please share your xaml, I will try convert your arrays to list tomorrow. Or someone will be able to help in the meanwhile.Is that Ok?

I am referring our previous XAML that splits through space as an array. Url is available here : Notepad to Excel write . Because of "system index out of range exception " we went to list to split and store the data. Now the list needs to be converted back in to fixed size array of (5). Again i am …

@ske you cannot add anything to an array.for eg: you last row has only two items but your array size is 5. I tried to validate the length and tried to add empty items to array but could not, so I used the list which can be used downstream. you can convert your list to array just by adding .ToArray(…

Yes we are on the same page. Due to this data nature i am facing more issues hope we have started this discussion last week. What about converting this sting to data table or Excel.Appreciate your help and hope you know the complexities we are facing. please suggest

System Index out of Range Exception

Help

SKE April 7, 2017, 1:55am 13

Initially we have started writing notepad content to excel :Notepad to Excel write - #7 by SKE . In the above url we constructed data table using the same data and faced the issue thats why i am asking this question Vinay

Topic		Replies	Views
Write Cell: Index was outside the bounds of the array error Help datatable , excel , uiautomation , studiox , question , exception_handling , microsoft_office365	2	2038	December 30, 2020
Index out of range in Datatable Help datatable , excel , activities	3	7451	November 16, 2017
Add Data Row: Index was outside the bounds of the array Help	3	2381	October 30, 2019
Convert List(of String) when using add data row activity and show object reference not set to instance Help datatable , activities	6	3168	July 10, 2019
Trouble looping datatable Help	10	956	February 13, 2020

System Index out of Range Exception

Related topics