Excel to Word automaaation

Help
1

Hi,
I want to create a bot which will read a column from Excel file(my excel sheet has just 1 column)-row by row , copy data of first cell and paste it into Word document and save the word document with the same name as pasted and save as pdf. This process should repeat for all cells of excel sheet.

Any help would be appreciated.
TIA.

Regards,
Vaishnavi

2

Use Read Range for reading Excel

Apply for each loop on DataTable you got from Read Range

Write To Word using Word Application scope

Save word as PDF

3

@Vaishnavi Attached zip file meets your requirement

ExcelToWord.zip (19.7 KB)

1 Like