Transfer Data from Excel to Word

GowsaliyanSoori — Fri, 31 Jan 2020 09:00:00 GMT

Hello dear congregation,

I have a question about the following problem. I would like to transfer data from Excel to Word to a continuous text.

In the process I came across the following problem. I don't know how to insert the content or the word from an Excel row e.g. (I14) in a Word document on a certain page e.g. on page 2 the word from Excel in the third sentence but as fourth word.

Do you have any ideas or even the solution to my problem?

Thanks for your help.

------------------------------
Gowsaliyan Sooriyakumaran
------------------------------

RE: Transfer Data from Excel to Word

Gerald_J — Wed, 26 Feb 2020 06:01:00 GMT

Hi Gowsaliyan,

There are multiple ways we can proceed with.

Method 1 :

> Use MS Excel VBO's to get the corresponding cell Value and store in a data item.

> Use MS Word VBO modify the code stage to include "Find and replace" action. if you want to include the retrieved data from excel and insert it in the document you can use this action to find the word and replace with existing word + retrieved value.

Ex. Excel Value (114) = NEW

Document Page 2 paragraph sentence contain = Hello! This is a wonderful world.

And you want to insert next to the word "wonderful"

you can use find and replace action where you will find the word "wonderful" and replace with "wonderful"+"New"

Result = Hello! This is a wonderful NEW world.

Method 2 :
>Read the word document MS Word VBO - Get Body

> Output will be stored in data item, you can use that and proceed with string manipulation techniques.

Method 3:
>Read the word document MS Word VBO - Get Body

> Output will be stored in data item, you can use that and proceed with regex.

Thanks,

------------------------------
Gerald J
Automation Engineer
10xds
Kerala/Kochi
+91-9159842805
------------------------------

topic RE: Transfer Data from Excel to Word in Product Forum

Transfer Data from Excel to Word

RE: Transfer Data from Excel to Word