Export Gridview and image to excel Report

Question

Hi every one

I am exporting gridview to excel and added a header heading by using html table tag along with that i need to add html tag for image also to export to excel

please help me for getting image from folder in my project solution to gridview export excel code as html tag calling src of image and then along with gridview add this image and export to excel

regads

saikiran gst

Saikiran Gst · Answer

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(  + imagepath +  ); // HttpContext.Current.Response.Write(  + imagepath +  ); HttpContext.Current.Response.Write( ReportReportReportReport ); HttpContext.Current.Response.Write( 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( ); 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 Maruthi · Answer

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/