Copying data from Excel to Word using Visual C#

Question

Greeting dear members, I would like to copy data from Excel to Word using visual c#. How can I do that? Regards, Ali

Rich Guernsey · Answer

Word. Range r = doc. Bookmarks . Item ( ref oEndOfDoc ) . Range ;

Ali Alfaraj · Answer

The source code is posted.

Dorababu Meka · Answer

Take a look here i don't know how far it helps you but just check once http://stackoverflow.com/questions/6310258/pasting-from-excel-into-a-word-document

Dorababu Meka · Answer

Can you attach the code what you have written so that i will make a try and try to resolve the issue

Ali Alfaraj · Answer

Please, can anyone help on this issue?

Ali Alfaraj · Answer

Thanks Dorababu M for the kind response. I managed to copy a number of cells from excel to word using the following c# code: xlWorkSheet.get_Range( "C5" , "F9" ).Copy( Missing .Value); // xlWorkSheet is the XL sheet oWord.Selection.Paste(); // oWord is the word sheet However, by default, the copied cells will be pasted on the top of the word document, meaning that any original data before the past command will be shifted down the page. How can I prevent that? I want to decide where to paste the cells within the word document rather than being done by default. Thanks in advance, Ali

Dorababu Meka · Answer

check this http://www.meadinkent.co.uk/excel-to-word.htm http://stackoverflow.com/questions/2672032/how-to-copy-a-formatted-cell-in-excel-to-a-table-cell-in-word-using-net

Copying data from Excel to Word using Visual C#

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)