Create Word Documents with excel row of data

Hi Team,

I have created the workflow based on excel file and pasted the values from excel to word document based on position.
I have an requirement to create multiple files with excel row of data and saving the files with file name dynamically.
ExcelWordValidation.zip (23.6 KB)
Appreciate your help.
@Palaniyappan @lakshman @sarathi125

@RajeshT

Do you want to read one by one row from Excel file and create word document and pass those values to it right ?

1 Like

@RajeshT,

Your implementation looks good, you need to uncomment the copy file activity to create a copy of your master template document.

Then you have to make sure that you are using correct extension, as of now you are using .doc, I think that should be changed to .docx.

And in the word application scope you have to use the same file which you have created/copied from the master template.

Shown the changes in the below image, please refer and let us know if you are facing any issues further on this.

Untitled

2 Likes

Exactly @lakshman,that what i am looking for and i want to save the word documents with file name mentioned in excel file as below:
image

1 Like

Hi @sarathi125,

This perfectly working,can we do this validation without opening the worddocs which means i should not see the word docs while the workflow is working.
This is because may be other word documents will be open while running the workflow.

@RajeshT,

With the current Word Application Scope Activity there is no way to disable opening the word application. But before starting with this process you can close/kill existing word doc application instances. So in that case your new word doc alone will be opened and modified.

For each document update you need to close the word doc and kill the word doc process.

1 Like

Thank you so much for your inputs @sarathi125

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