Send table details as excel attachment

Question

0.00/5 (No votes)

See more:

I am doing Project in shopping cart.if user select an item ,i want to send
Item Image ,Item Code, Item Name as excel attachment.
Firstly i add all these datas in gridview and I use following code.

C#

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.

Posted 21-Jun-12 23:13pm

Deepthy.P.M

Updated 21-Jun-12 23:20pm

Manas Bhardwaj

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vangapally Naveen Kumar · Answer 1 · 2012-06-21T23:22:00

try like this

C#

//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[^]

Send table details as excel attachment

1 solution

Solution 1

Add your solution here

Preview 0

Send table details as excel attachment

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us