export image from gridview to excel

Hi,

I have a gridview with a image and my image or image path is not storing in db. Its common for all pages.

So how to export gridview with image to excel .

I searched i am getting solution that images are stored in db.

Below is my aspx code.

CS Code for exporting:

protected void btnwexport_Click(object sender, EventArgs e)

{

Response.Clear();

Response.Buffer = true;

Response.AddHeader("content-disposition", "attachment;filename=WeeklyECGReport.xls");

Response.Charset = "";

Response.ContentType = "application/vnd.ms-excel";

using (StringWriter sw = new StringWriter())

{

HtmlTextWriter hw = new HtmlTextWriter(sw);

//To Export all pages

//grddaily.AllowPaging = false;

this.fillgrid();

grdweekly.HeaderRow.BackColor = Color.White;

foreach (TableCell cell in grdweekly.HeaderRow.Cells)

{

cell.Width = 140;

cell.Height = 190;

break;

}

grdweekly.RenderControl(hw);

//style to format numbers to string

string style = @"";

Response.Write(style);

Response.Output.Write(sw.ToString());

Response.Flush();

Response.End();

}

Pls Help me.. Its very urgent.

2 Replies

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

Priya Bm11y ago
Thank you sir for your response.
I checked all these links.. They are taking from db.. My image is static.. I am not storing in db.
0
Yashwanth Muthineni11y ago
Hi,
Checkout the below links.. it may helpful..

http://www.codeproject.com/Questions/264322/How-to-export-image-to-Excel-from-Gridview

http://www.codeproject.com/Questions/303041/Export-gridview-to-excel-with-images
+1