How to embed grid images into excelwhile exporting gird to excel and saving the excel.

Question

Hi I had a gridview with imageswhile i export the grid view to excel all the images are embeded into excel in the open mode. if i try to save the exported data the images are missing.Please help me how to achieve this.

Master Billa · Answer

Hi use this code to this just copy and paste to ur button click. private void Excel_Export() { Response.Clear(); Response.Buffer = true; Response.AddHeader(content-disposition attachment;filename=GridViewExport.xls); Response.Charset = ; Response.ContentType = application/vnd.ms-excel; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GridView1.AllowPaging = false; GridView1.DataBind(); for (int i = 0; i { GridViewRow row = GridView1.Rows[i]; //Apply text style to each Row row.Attributes.Add(class textmode); } GridView1.RenderControl(hw); //style to format numbers to string string style = @ .textmode { mso-number-format:\@; } ; Response.Write(style); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); } thank you

Amit Choudhary · Answer

Rakesh I'm confused about your question.....

R · Answer

Hi Amit Thanks for the reply. My idea is to upload a grid with images into excelso i can achieve this by just rendering the Grid into Streamwriter.By this approch images are getting referenced by their url's so if user opens the exported excel it is fine and if he saves it also works untill the connectivity between the user machine and the server is avail. Thanks Rakesh

Amit Choudhary · Answer

Export the html page With images into excel: string GridName =Demo HttpContext.Current.Response.ContentType = application/vnd.ms-excel; HttpContext.Current.Response.AddHeader( content-disposition  attachment;filename= & GridName & .xls ); HttpContext.Current.Response.Charset = ; System.IO.StringWriter tw =new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw =new System.Web.UI.HtmlTextWriter(tw); Page.RenderControl(hw); HttpContext.Current.Response.Write(tw.ToString()); HttpContext.Current.Response.End(); Don't forget Mark the answer

How to embed grid images into excel,while exporting gird to excel and saving the excel.