How to take data from excel and enter it to a excel or word

Automation Studio
1

I am having a requirement to insert data from excel to either word or pdf. I am a new user please help. I have to take one by one entry from excel and paste it in word/pdf accordingly in the form.

1 Like
2

Hi,

Using Excel loop read the excel rows and paste the same in Word application

Regards,
Amit Anand

4

when i am selecting a excel file and confirming output parameters, the application is getting hanged. What could be the reason. can u pls help.

5

HI,

Check your system utilization and see what process is consuming memory and cpu.

Regards,
Amit Anand

6

Hi,

Yes I checked everything is fine but every time that particular excel file output parameters are getting hanged and then I have to close the application.

7

Hi,
now m able to take value from excel but how to enter it at proper place in word file, for me it is coming at start but I need to place it at one particular table entry

8

Hi,

Let’s say I want to enter value at this cell (where the cursor is)
image

  1. I added conifguration for Word application and first captured the MouseClick interaction and changed the control index=3, as in my case I want to paste in cell index=3.
  2. Then I conifgured the interaction as Set Text and again changed the control index=3. for the Set Text interaction, you can set input = the Excel file header
    image
    image

Hope this helps.

Thanks,
Anshu