Exporting chart and gridiew to Excel

I have a situation where I have to export gridview and chart in the same excel file without using Interop (MicroSoft). Here is my code

Response.ClearContent();

Response.Buffer = true;

Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Prosperity.xls"));

Response.ContentType = "application/ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

grdPremiumAnalysis.AllowPaging = false;

BindReportInGridView();

grdPremiumAnalysis.HeaderRow.Style.Add("background-color", "#FFFFFF");

for (int a = 0; a < grdPremiumAnalysis.HeaderRow.Cells.Count; a++)

{

grdPremiumAnalysis.HeaderRow.Cells[a].Style.Add("background-color", "#507CD1");

}

int j = 1;

foreach (GridViewRow gvrow in grdPremiumAnalysis.Rows)

{

gvrow.BackColor = Color.White;

if (j <= grdPremiumAnalysis.Rows.Count)

{

if (j % 2 != 0)

{

for (int k = 0; k < gvrow.Cells.Count; k++)

{

gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");

}

j++;

}

grdPremiumAnalysis.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

string imgPath1 = (Request.Url.GetLeftPart(UriPartial.Authority) + VirtualPathUtility.ToAbsolute("~/" + newPremChart));

string imgPath2 = Request.Url.GetLeftPart(UriPartial.Authority) + VirtualPathUtility.ToAbsolute("~/" + premIncome);

Response.Clear();

Response.ContentType = "application/vnd.ms-excel";

Response.AddHeader("Content-Disposition", "attachment; filename=ebs1.xls;");

Response.AddHeader("Content-Disposition", "attachment; filename=ebs2.xls;");

StringWriter stringWriter1 = new StringWriter();

StringWriter stringWriter2 = new StringWriter();

HtmlTextWriter htmlWrite1 = new HtmlTextWriter(stringWriter1);

HtmlTextWriter htmlWrite2 = new HtmlTextWriter(stringWriter2);

string headerTable1 = @"

string headerTable2 = @"

Response.Write(headerTable1);

Response.Write(headerTable2);

Response.Write(stringWriter1.ToString());

Response.Write(stringWriter2.ToString());

Response.End();

this is my Code Where i m going wrong

3 Replies

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

Munesh Sharma10y ago
http://www.c-sharpcorner.com/UploadFile/jayendra/export-to-excel-functionality-in-Asp-Net-chart-control/
FIROZ ANSARI10y ago
Thanks
Mr. darjeam nh
Rahul Prasad10y ago
Hi, you'd better point out where the error was caused and what your error is, which can help others provide you solutions accordingly. In addition, i suggest you use the Spire.XLS to export data from gridview to Excel without dependence of MS Office.

http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Export-Data-from-Database-to-Excel-for-WPF.html