2
Answers

export image from gridview to excel

Priya Bm

Priya Bm
9y
871
1
 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.
<div class="box">
<asp:GridView ID="grdweekly" runat="server" CssClass="GridReport" OnRowDataBound="grdweekly_RowDataBound">
<Columns>
<asp:TemplateField>
<HeaderTemplate>
<asp:Image ID="Image1" runat="server" ImageUrl="Images/Elephant.png" />
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%#Eval("WeekNo") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
 
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 = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
 
Pls Help me.. Its very urgent. 
 
 
Answers (2)
Next Recommended Forum