Export Gridview and image to excel Report

Hi ramesh

Firstly thanq for sending some information about my problem but what u send is for exporting image from database or girdview image to export its not my problem solution what my problem is i need to export gridview text data and along with that image from my project solution images folder to one image and gridview data combinding both and export to excel if possible please help me

I am sending code also check it

code behind
-----------

using System;

using System.Data;

using System.Drawing;

using System.IO;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace Login.Account

{

public partial class ExportExcel : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridview();

}

protected void BindGridview()

{

DataTable dt = new DataTable();

dt.Columns.Add("UserId", typeof(Int32));

dt.Columns.Add("UserName", typeof(string));

dt.Columns.Add("Education", typeof(string));

dt.Columns.Add("Location", typeof(string));

dt.Rows.Add(1, "SureshDasari", "B.Tech", "Chennai");

dt.Rows.Add(2, "MadhavSai", "MBA", "Nagpur");

dt.Rows.Add(3, "MaheshDasari", "B.Tech", "Nuzividu");

dt.Rows.Add(4, "Rohini", "MSC", "Chennai");

dt.Rows.Add(5, "Mahendra", "CA", "Guntur");

dt.Rows.Add(6, "Honey", "B.Tech", "Nagpur");

gvDetails.DataSource = dt;

gvDetails.DataBind();

}

public override void VerifyRenderingInServerForm(Control control)

{

/* Verifies that the control is rendered */

}

protected void btnExport_Click(object sender, EventArgs e)

{

try

{

GridView[] gvList = null;

gvList = new GridView[] { gvDetails };

ExportAv("Report.xls", gvList);

}

catch (Exception ex)

{

}

public static void ExportAv(string fileName, GridView[] gvs)

{

HttpContext.Current.Response.Clear();

HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));

HttpContext.Current.Response.ContentType = "application/excel";

System.IO.StringWriter sw = new System.IO.StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

foreach (GridView gv in gvs)

{

gv.AllowPaging = false;

// Create a form to contain the grid

Table table = new Table();

if (gv.ID == "gvDetails")

{

TableRow title = new TableRow();

title.BackColor = Color.Cyan;

TableCell titlecell = new TableCell();

titlecell.ColumnSpan = 3;//Should span across all columns

Label lbl = new Label();

lbl.Text = "XYZ REPORT 2014";

titlecell.Controls.Add(lbl);

title.Cells.Add(titlecell);

table.Rows.Add(title);

}

table.GridLines = gv.GridLines;

// add the header row to the table

if (!(gv.Caption == null))

{

TableCell cell = new TableCell();

cell.Text = gv.Caption;

cell.ColumnSpan = 4;

TableRow tr = new TableRow();

tr.Controls.Add(cell);

table.Rows.Add(tr);

}

if (!(gv.HeaderRow == null))

{

table.Rows.Add(gv.HeaderRow);

}

// add each of the data rows to the table

foreach (GridViewRow row in gv.Rows)

{

table.Rows.Add(row);

}

// add the footer row to the table

if (!(gv.FooterRow == null))

{

table.Rows.Add(gv.FooterRow);

}

// render the table into the htmlwriter

table.RenderControl(htw);

}

// render the htmlwriter into the response

// String imagepath = "

String imagepath = "

HttpContext.Current.Response.Write("

");

// HttpContext.Current.Response.Write("

");

HttpContext.Current.Response.Write("

");

HttpContext.Current.Response.Write("

");

HttpContext.Current.Response.Write("

" + imagepath + "

ReportReportReportReport

" + DateTime.Now.ToString("d") + "

");

HttpContext.Current.Response.Write("
");

//string headerTable1 = @"

//string headerTable = @"

// string headerTable = @"

ReportReportReportReport

" + DateTime.Now.ToString("d") + "

// HttpContext.Current.Response.Write(headerTable1);

//HttpContext.Current.Response.Write("
");

// HttpContext.Current.Response.Write(headerTable);

HttpContext.Current.Response.Write(sw.ToString());

HttpContext.Current.Response.End();

}

2 Replies

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

Saikiran Gst12y ago
Hi ramesh

Firstly thanq for sending some information about my problem but what u send is for exporting image from database or girdview image to export its not my problem solution what my problem is i need to export gridview text data and along with that image from my project solution images folder to one image and gridview data combinding both and export to excel if possible please help me

I am sending code also check it

code behind
-----------
using System;
using System.Data;
using System.Drawing;
using System.IO;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Login.Account
{
public partial class ExportExcel : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridview();
}
}
protected void BindGridview()
{
DataTable dt = new DataTable();
dt.Columns.Add("UserId", typeof(Int32));
dt.Columns.Add("UserName", typeof(string));
dt.Columns.Add("Education", typeof(string));
dt.Columns.Add("Location", typeof(string));
dt.Rows.Add(1, "SureshDasari", "B.Tech", "Chennai");
dt.Rows.Add(2, "MadhavSai", "MBA", "Nagpur");
dt.Rows.Add(3, "MaheshDasari", "B.Tech", "Nuzividu");
dt.Rows.Add(4, "Rohini", "MSC", "Chennai");
dt.Rows.Add(5, "Mahendra", "CA", "Guntur");
dt.Rows.Add(6, "Honey", "B.Tech", "Nagpur");
gvDetails.DataSource = dt;
gvDetails.DataBind();
}
public override void VerifyRenderingInServerForm(Control control)
{
/* Verifies that the control is rendered */
}
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
GridView[] gvList = null;
gvList = new GridView[] { gvDetails };
ExportAv("Report.xls", gvList);
}
catch (Exception ex)
{

}
}
public static void ExportAv(string fileName, GridView[] gvs)
{

HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);

foreach (GridView gv in gvs)
{
gv.AllowPaging = false;

// Create a form to contain the grid
Table table = new Table();
if (gv.ID == "gvDetails")
{
TableRow title = new TableRow();
title.BackColor = Color.Cyan;
TableCell titlecell = new TableCell();
titlecell.ColumnSpan = 3;//Should span across all columns
Label lbl = new Label();
lbl.Text = "XYZ REPORT 2014";
titlecell.Controls.Add(lbl);
title.Cells.Add(titlecell);
table.Rows.Add(title);
}
table.GridLines = gv.GridLines;
// add the header row to the table
if (!(gv.Caption == null))
{
TableCell cell = new TableCell();
cell.Text = gv.Caption;
cell.ColumnSpan = 4;
TableRow tr = new TableRow();
tr.Controls.Add(cell);
table.Rows.Add(tr);
}

if (!(gv.HeaderRow == null))
{
table.Rows.Add(gv.HeaderRow);
}
// add each of the data rows to the table
foreach (GridViewRow row in gv.Rows)
{
table.Rows.Add(row);
}
// add the footer row to the table
if (!(gv.FooterRow == null))
{
table.Rows.Add(gv.FooterRow);
}
// render the table into the htmlwriter
table.RenderControl(htw);
}
// render the htmlwriter into the response
// String imagepath = "";
String imagepath = "";
HttpContext.Current.Response.Write("
HttpContext.Current.Response.Write("
");
// HttpContext.Current.Response.Write("
");
HttpContext.Current.Response.Write("
");
HttpContext.Current.Response.Write("
");
HttpContext.Current.Response.Write("
" + imagepath + "
" + imagepath + "
ReportReportReportReport
ReportReportReportReport
" + DateTime.Now.ToString("d") + "
");
HttpContext.Current.Response.Write("
");
HttpContext.Current.Response.Write("
");
HttpContext.Current.Response.Write("
");
HttpContext.Current.Response.Write("
");
HttpContext.Current.Response.Write("
");
//string headerTable1 = @"
";
//string headerTable = @"
";
// string headerTable = @"
ReportReportReportReport

" + DateTime.Now.ToString("d") + "
";
// HttpContext.Current.Response.Write(headerTable1);
//HttpContext.Current.Response.Write("
");
//HttpContext.Current.Response.Write("
");
//HttpContext.Current.Response.Write("
");
//HttpContext.Current.Response.Write("
");
//HttpContext.Current.Response.Write("
");
// HttpContext.Current.Response.Write(headerTable);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
Ramesh Maruthi12y ago
http://www.aspsnippets.com/Articles/Export-GridView-with-Images-to-Word-Excel-and-PDF-Formats-in-ASP.Net.aspx

http://social.msdn.microsoft.com/Forums/vstudio/en-US/03a10011-61c2-48f1-be75-fc773cf0d171/export-gridview-with-images-to-excel?forum=csharpgeneral

http://www.c-sharpcorner.com/UploadFile/8911c4/export-html-grid-view-and-image-to-excel-sheet-using-asp-ne/