Excel to Word form

Help Forum
1

Hi,

Could you please let me know how to fill a form in word document by reading data from excel. Excel file contains list of student names, gender, section etc…

Below is the word document which needs to be filled.

image
image1261×565 54.6 KB

2

@aishwarya1

  1. Create one word template file. Write some dummy text in place of text you want to update it from Excel file.

  2. Next use Read Range activity to read the text Excel file and it will give output as DataTable.

  3. Then use For Each Row activity to iterate DataTable.

    a. Use Copy File activity to copy word template to some location.

    b. Then use Replace Text activity and replace that dummy text with Excel file data and this activity should be inside Word Application Scope activity.

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.