Export winform chart to excel

Question

4.00/5 (1 vote)

See more:

, +

Hi,

I have a winform chart in C# and I would like to export this into excel, preferably so that I can edit or whatever in excel. I found an example on how to export it as a GIF file, but that is not what I want.

Hopefully someone is able to help :)

Thx

Posted 6-Nov-13 1:17am

Handyman83

Add a Solution

Comments

thatraja 6-Nov-13 7:54am

winform chart? what's that? MS chart?

Handyman83 6-Nov-13 8:53am

A data chart where you present statistic in e.g columns or line.

thatraja 6-Nov-13 9:03am

data chart? No idea. For charts, I did use Crystal reports & MS Chart. So which component you're using for chart. Complete details please

Handyman83 6-Nov-13 10:24am

I really dont understand What you want to know. I have a window popping up with a chart on it displaying fuel consumption on the y axis and days of month on the x axis. Now I want a button to export this into an MS excel spreadsheet.

thatraja 6-Nov-13 10:34am

My mistake, I should have you for the code. Actually I didn't know that winform(new version) has chart option. That's why I asked you about component details. I'm not a winform developer. So right solutions from me now. I'll try to come here later. Alternatively you could try this one. How to create Excel Chart from C#

2 solutions

Solution 1

Hello Handyman83,

As far as I know, what you are trying to do would be possible only if you build the chart through sending c# data to an excel spreadsheet. I've done some research and found this link http://csharp.net-informations.com/excel/csharp-excel-chart.htm[^]. I hope it will help you with your needs.

Good Luck,

Posted 6-Nov-13 4:27am

Paulo Augusto Kunzel

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)

BillW33 · Accepted Answer · 2013-11-06T05:08:00

It is not clear from your question exactly what you want to do. It sounds like, since you don't want to copy a image (gif file) to Excel that what you want is to copy the data that is in the chart into an Excel spreadsheet.
One way of transferring data from a C# program to Excel is to save the data to a CSV file. A CSV file (Comma-Separated Values) can be opened by Excel.
At this link[^] are some basic examples of exporting data to a CSV file.

You don't specify which version of Excel you are working with, but if it is from Office 2007 or later you can use the Open XML SDK[^]. CodeProject even has an article[^] about how to use this SDK.

If you want your code to create an actual chart in Excel that is also possible. Take a look at this link[^] to get started.

After you have written some code to transfer the data and you get stuck feel free to ask questions here. Include the code you have written so far as well as a detailed description of any error messages.