How to export 2 gridview and chart into excel?

Tushar Goel

Hi,

I am new to this and have a requirement to export 2 gridviews and chart into same excel sheet using c#. Any help is much appreciated.
Regards
Tushar Goel

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
refer how to save the chart
0
Tushar Goel15y ago
I am using Microsoft chart control. i have created one temp image folder in c:\\. now when i click on the button , one text file is added in that folder but no image. So, i cannot use tht path for upload the image as per ur post.. Sorry, for asking many question..
0
Suthish Nair15y ago
whats the problem you facing now. Which chart control you using?
0
Tushar Goel15y ago
Sorry, that dint help..
0
Sam Hobbs15y ago
I don't know about the chart(s) and you probably need to be more specific about that.

To export data from a gridview, if this is for an ASP .Net application then it should be in an ASP .Net forum.

Theoretically speaking, a GridView or a DataGridView typically has data from a data source such as a database. If it does, then it is usually easier to export from the data source, not the control.

You can write to the Excel worksheet in one of two ways; either using ADO .Net or by using the Excel object model. Probably ADO .Net would be easier but what to use depends on various things, such as your personal preference.
0
Suthish Nair15y ago
The link i posted didnt helped?

0
Tushar Goel15y ago
I am able to export multiple gridviews into excel but cannot able to export chart into same excel. I am looking for that..
0
Mahesh Chand15y ago
On Export button, I suggest you create a DataSet from data coming from both GridView controls, then create an in-memory GridView and then Export. At least this is one way to do it.
0
Suthish Nair15y ago
First of all you need to save your chart image to a drive location.

Refer below article to export to excel.

Export Image to Microsoft Office Excel using C#
0