Filling Word application using Word activity taking too much time

AM trying to fill a word application from Excel input. This is the below step am following.

  1. Reading excel
  2. Reading a word template
  3. Running the for each loop and am replacing the text with Excel data.

Note : Am replacing 45 text in word, and its taking 5 minutes to complete the entire Process. i do have 16000 documents to be prepared like this.

Is there any way i can make this process run faster?

Hi @Manikandasamy ,

Are you using the StudioX Activity to perform the operation in MS Word?
If so, I would recommend switching over to the Classic Activity instead

image

image

If this is not what you were looking for, then some sample data would be most appreciated.

Kind Regards,
Ashwin A.K

Hi

We need to see at which place it is taking more time
Is it when reading excel or with word

Try running in debug mode and see which activity takes more time

And in the other side upgrade the excel and word package in your studio and give a try

@Manikandasamy

@Palaniyappan Hope you are doing good.

Thanks for the reply. The robot is taking so much of time in “replace text activity”.

We need to replace 45 texts know, there its taking so much time :slight_smile:

Hi Ashwin, No am not using StudioX activity.

Hi @Manikandasamy ,

We would appreciate it if you could provide us with some sample data, both the Excel and the Word file so that we can help you out with a proper end to end resolution.

If the documents contain sensitive data then few lines of dummy data is more than enough.

Kind Regards,
Ashwin A.K

The upload is restrcited from our end,

I have attached the below link where you can download a sample document.

http://www.iitk.ac.in/dosa/Swimming/files/application_form.htm

Hi @Manikandasamy ,

Are you using placeholders in the MS Template to replace the text with what is present in Excel?

Kind Regards,
Ashwin A.K

Am using Replace.Text.Word in the code inside word application scope