将表格详细信息作为excel附件发送 [英] Send table details as excel attachment

问题描述

我正在购物车中进行项目.如果用户选择一个项目，我想发送
项目图片，项目代码，项目名称作为excel附件.
首先，我将所有这些数据添加到gridview中，并使用以下代码.

 StringWriter sw = 新 StringWriter();
HtmlTextWriter htw = 新 HtmlTextWriter(sw);
gridview .RenderControl(htw);

System.Text.Encoding enc = System.Text.Encoding.ASCII;
字节 [] myByteArray = enc.GetBytes(sw.ToString());
System.IO.MemoryStream memAtt = 新 System.IO.MemoryStream(myByteArray， false );
mail.Attachments.Add(新附件(memAtt，" )); 

它工作正常，但是附件excel会显示除项目image之外的详细信息.有没有办法在附件excel表中显示图像.

 // 生成Excel 
  Response.Clear();
        Response.AddHeader(" ，" 附件； filename = NAVEEN.xls")；
        Response.Charset = " ;

        Response.ContentType = " ;
        System.IO.StringWriter stringWrite = 新 System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = 新 HtmlTextWriter(stringWrite);
        GridView1.RenderControl(htmlWrite);
        Response.Write(" );
        Response.Write(stringWrite.ToString());
        Response.End(); 

或
看到此链接类似的讨论
http://forums.asp.net/t/1639973.aspx [StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); gridview .RenderControl(htw); System.Text.Encoding enc = System.Text.Encoding.ASCII; byte[] myByteArray = enc.GetBytes(sw.ToString()); System.IO.MemoryStream memAtt = new System.IO.MemoryStream(myByteArray, false); mail.Attachments.Add(new Attachment(memAtt, "product.xls"));

It working fine but,The attachment excel display details except item image.is there any way to display image in attached excel sheet.

解决方案

try like this

//generating excel
  Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=NAVEEN.xls");
        Response.Charset = "";

        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        GridView1.RenderControl(htmlWrite);
        Response.Write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />");
        Response.Write(stringWrite.ToString());
        Response.End();

or
see this link similar discussion
http://forums.asp.net/t/1639973.aspx[^]

这篇关于将表格详细信息作为excel附件发送的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！