Loop through excel rows and create letters using Word template

I am trying to create a process that requires looping through all the excel rows and copy data into a word document template and save it as PDF

- what is the best way to loop through all the rows

- is there any option to enter data into Word document or do we need to have the template in Excel

- how do we save Word or Excel into PDF format?

Thanks,

Santosh

Developer Tools

Accepted answers

wwatson

You'll have to build the format of the page output using the reporting tools. You can save to PDF with the render tool, just change the output type from docx to pdf.

pdf outputs.yxmd

All comments

wwatson

I'm not really sure what you mean by looping through the rows. Perhaps a multi-row formula too is what you are looking for.

You can save to PDF or Word using the Render tool in the Reporting pallet.

Muralisagar

HI,

thank you for your response

by looping I mean, I have 100 rows in excel with each candidate information. the requirement is to create certificate for each candidate using a word template (by copying each candidate's info into work and save as). In essence, particular action need to be performed for each and every row of the excel input

thanks,

Muralisagar

sorry for not explaining it clearly, I need 100 PDFs to be exported if there are100 rows in the Excel spread sheet (each PDF will have info from each row)

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703