Fill out pdf from excel sheet

Help
, ,
1

Hello All

I have new hire excel sheet with data like name and email and I have pdf from
I need to copy each new hire details to pdf form and print out for each one

can some help me

Thanks

2

hi, welcome to the community!
Where are you stuck on your project? I assume you already started it right?

3

can you share me the pdf template screenshot?

4

Yes I did here is the SC for the PDF and the sheet
image

image
image951×183 6.13 KB

I use read cell but that will take forever if I have 400 new hire

image
image521×1108 47.6 KB

image
image433×969 45.5 KB

so I’m looking for a faster way

5

I also tried For Each Row then AB assign but again I end up with the same thing
how I can do that for all the sheet with write very long program

image
image478×692 36.2 KB

6

Hi, you want to use the Read Range activity in excel scope so all rows and cells will be read at once, it will be A LOT faster, after that a DataTable will be generated and you will use a For Each Row activity (a loop) that will go through all your employees :slight_smile:

7

can you send me screenshot how it can be done. Thanks

8

you would just replace you several Read Cell activities with one Read Range…

9

but how I call the data to fill the PDF fill

10

What do you mean call the data? you should just open the pdf as a human would and use Type Into i guess…

11

not sure how I make For Each Row activity to loop

12

Look at this example where I am reading excel and traversing through each cell data.
Hope this would help you.

AutomationChallenge.zip (40.2 KB)

13

AOA! Hi…
please u can tell me that how i can excel data in each row display in pdf file template in seperate Boxes…?
please help me…
Thanks in Advance.
customers.zip (892.9 KB)