It is working fine, but what exactly i need is to get each cell data one by one. The above expression outputs me single row data in the form of a list.But, what i want is when i repeat a loop it should display only 1 first time, Alex second time, Manager 3rd time…
If you want to add items from one row to the List you have to put Add to collection Block into the second For each. But first of all you should initialize this List by using assign NewList = new List( of String/Object/whateveryouwnt) before first each.
am i right?
I have created a basic bot , from which you can get values present in the excel cell vertically and horizontally. Hope it will help you all:). Reading_Excel_data.zip (6.3 KB)