I have difficulties with creating a process which need some help and ideas from everyone who able to help.
I have one excel file which have data on producs as below:
I need to read the product id by by box which each Box has 25 product id. And the product id need to be read one by one and fill in into the website form one by one .
For example, I read productid 1 from Box 1 and fill into website form and then click enter . Then continue read productid 2 from Box 1 and fill into website form and then enter. Follow by all those 25 product id . Then I have to save all those 25 product id inserted .
Then read Box 2 data and follow by others.
My issue is that I am not sure how to read the data in that pattern. I use read range to read the whole sheet and output into datatable
Then i use for each to read row, but when I assign the column name to ‘Box 1’ . The uipath prompt error , no Box 1 in datatable.
I really hope anyone can help me on this.