Insert a value from Excel cell to Word document

Question

I have two documents, one Word and other Excel document(word.docx and excel.xlsx). In a Word document, I have something like " My salary for this month is (empty), and I worked (empty1) days." So that instead of (empty) insert a value of, for example, cell B12 from Sheet1, and instead of (empty1) insert a value of cell F10 from Sheet2.

Is it possible?

This post might help, but I'd recommend creating a consolidated sheet for use with the mail merge for keeping things simple answers.microsoft.com/en-us/office/forum/office_2007-word/… — Steph Locke
The quick answer is "Yes - it is possible" ... what have you tried so far? — MikeD

mike27015 mike27015 · Accepted Answer · 2013-06-13T12:55:12

Indicate which language you plan to use. I would suggest C#. You might look up for Microsoft.Office.Interop Word and Excel and work with shapes. Another possible solution would be the OOXML, but its way more complexe to understand.

http://msdn.microsoft.com/fr-fr/library/microsoft.office.interop.word.document%28v=office.11%29.aspx http://msdn.microsoft.com/en-us/library/dd264733.aspx http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/8fc4b3f0-acda-4db0-8b81-56a6157a5f4c http://social.msdn.microsoft.com/Forums/en-US/worddev/thread/fa6ae29a-7a7b-4d4b-a419-3c42706b2b39 http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/e8ca1e64-f71a-4be9-aa86-9d968910d029 http://social.msdn.microsoft.com/Forums/en-US/officegeneral/thread/58ee824a-7365-4020-90a1-a4a6405d86a7 Showing HTML in PowerPoint

Those are forums which you can visit and find out more about how to open Excel and Powerpoint with C#

Insert a value from Excel cell to Word document

1 Answers