Excel Programming in C# copy,paste feature

Question

4.00/5 (1 vote)

See more:

.NET3.0

, +

Hello All,

I have made an application which does some excel programming in c#.

Basically it reads data from col1 and col2 and then generates chart from that.
Now I have 100+ charts so what I want to do is copy all those charts from excel worksheet and paste them all in new Microsoft Word document or another option could be copy and paste all charts in excel first then convert excel file to Microsoft Word file.

I have tried all possibilities but I couldn't find anything called copy/paste for Microsoft word.

Thanks and cheers,
Mohit.

Posted 16-Mar-11 9:11am

mohit`12

Updated 16-Mar-11 10:46am

Dalek Dave

v3

Add a Solution

2 solutions

Solution 2

In answer to the other question about sheet names...
see here[^].

Posted 16-Mar-11 10:49am

Dalek Dave

Comments

Espen Harlinn 16-Mar-11 19:12pm

Right - 5ed!

Albin Abel 17-Mar-11 5:34am

Right link

mohit`12 17-Mar-11 9:12am

thanks but i was looking for Microsoft.Office.Interop.Word; i know how to add sheet name in excel.
if you know how to exact same thing for Microsoft word let me know thanks

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Henry Minute · Accepted Answer · 2011-03-16T09:21:00

Solution 1

It sounds as if you need Microsoft Office Interop[^].

This will enable you to perform practically any Office operation.

Posted 16-Mar-11 9:21am

Henry Minute

Comments

mohit`12 16-Mar-11 15:46pm

thanks alot that solved my problem in seconds.. :D thanks again

Cheers

mohit`12 16-Mar-11 16:05pm

i was also wondering if you know how can you change name of your document when i tried sheet.name="BB" it says document is readonly cannot change name. :/

Henry Minute 16-Mar-11 16:10pm

I am not 100% sure as I have never had to do that, but if it was me I would try 'Save As'. Of course you would then need to delete the original, if the above works but I'm sure that if you dig around you might find a way to do it in Interop. If not use the plain old C# File.Delete() method.

If none of that works, then I can only suggest you ask a fresh question.

Good luck! :)

Espen Harlinn 16-Mar-11 19:12pm

5ed!

Albin Abel 17-Mar-11 5:33am

My 5