Pasting rows to a website where rows may repeat

Help StudioX
,
1

I currently have an excel sheet and a website where I need to transfer information from the excel sheet to the website and tick the UKCA box on active rows. Please see letters inside the pictures below for where I need each excel cell to transfer to website data:

image
image973×139 31 KB

image
image975×128 38.5 KB

So far, I have the following chain:

  • Use excel file
  • Use browser
  • For each excel row (in table1)
  • For each UI element (this looks at all the numbers along the left hand side which is the PO number on the excel sheet)
  • If currentindex = PO line number on the row
  • Then click (arrow). This opens the table on the website

I would be able to easily paste in the first row but because different PO lines have different numbers of rows, there could be up to 100 tables generated! How could I get the data to paste over so if it detects data in the first relevant box, it will move on to the next relevant box

The table on the screen will be the only active table as all the others will have minimized due to the arrow on the left of the website not being clicked

Sorry if I have missed any data, please let me know if any more information is needed and thanks to anyone who can assist with this!

2

@jbarrett

can you show a short recording to understand..as of now what I understand is you need to write data from excel to some app…in excel po might have multiple rows and all row items should go into one page of app..

if this is what is needed instead of for each row in excel ..you need to read the data first into datatable then group by the PO number to get all the po numbers as one item and then loop on each PO or group

dt.AsEnumerable.GroupBy(function(x) x("PO Number").ToString).ToDictionary(function(x) x.Key,function(y) y.CopyToDataTable) rhis will create a dictionary with po number and its related table of info which can be looped

and then writing to app depends on how the UI is may be you can loop through each line in the respective PO tables

cheers

1 Like
3

Hi Anil,

I managed to figure it out in the end by utilising the clipboard and multiple other factors. I really appreciate the feedback though, thanks! :slight_smile:

1 Like