Hello and thank you in advance for any help.
I have a couple of issues with what I’ve attached. I’ve attached the UI Path project I am working on and I’ve also attached the data table and the Excel template.
The first three pieces of this project work fine
1.Open DS LOA Ishare
3. Excel - save the table
Once I’ve saved the data table I’m using a for each loop to iterate through it and pull out each waybill number (the variable is “awb” without quotes).
The problem I’m having is that I can’t get the For Each loop to work correctly. The For Each loop is supposed to pull each awb and paste it into cell F8 of the attached Excel template (called DS LOA template) and then save it as a PDF with the awb variable as the PDF name. For example, if the first awb is 123456789, the first saved template would similarly be named 1234567899.pdf. Right now it saves the first only but the file name is awb.pdf. The other issue is that the for each is pulling the wrong column of data. Instead of pasting the awb variable it is pasting the column with the employee names.
Can someone take a look and help me? I feel like I’m close but not close enough