How to Export in Excel

dhoni kholi

6y1.2k.NET

This is my Code

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div id="page-wrapper" >
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading">
<h3 style="text-shadow: 2px 2px #79aed8;">Barcode List h3>
div>
<div class="panel-body">
<div id="Barcode">
<h1 align="center"
style="text-decoration: underline; font-size: x-large; font-weight: bold">Barcodeh1>
<asp:Panel ID="Panel1" runat="server">
<asp:Label ID="lblPname" runat="server" Text="" Font-Bold="True">asp:Label>
<br />
<%-- <asp:PlaceHolder ID="phBarcode" runat="server" Visible="true">asp:PlaceHolder>
asp:Panel>--%>
<asp:Image ID="Image1" runat="server" Height="70px" Width="250px" />
<div class="table-responsive";>
<table class="table">
<tbody>
<tr>
<td>
<asp:Button ID="btnPPdf" runat="server" Text="Print" CssClass="btn-info"
Width="100px"/>
<asp:Button ID="btnExcel" runat="server" Text="Excel" CssClass="btn-success"
Width="100px" onclick="btnExcel_Click" />
<asp:Button ID="btnBack" runat="server" Text="Back" CssClass="btn-danger"
Height="35px" Width="100px" />
td>
tr>
tbody>
table>
div>
div>
div>
div>
div>
div>
asp:Content>

I want export to Excel in Content of Inside the Panel

I use this Code this

protected void btnExcel_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
Panel1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}

My output is

I want that Lable and Image

8 Replies

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

Laxmidhar Sahoo6y ago
The detais of the function is given link may clearify you
https://www.aspsnippets.com/Articles/Export-Image-to-Excel-file-in-ASPNet-using-C-and-VBNet.aspx
Local Coders6y ago
1. protected void ExportExcel(object sender, EventArgs e)
2. {
3. //Convert the Relative Url to Absolute Url and set it to Image control.
4. Image1.ImageUrl = this.GetAbsoluteUrl(Image1.ImageUrl);
5. using (StringWriter sw = new StringWriter())
6. {
7. using (HtmlTextWriter hw = new HtmlTextWriter(sw))
8. {
9. //Create a Table.
10. Table table = new Table();
11. //Add Image control to the Table Cell.
12. TableRow row = new TableRow();
13. row.Cells.Add(new TableCell());
14. row.Cells[0].Controls.Add(Image1);
15. table.Rows.Add(row);
16. //Render the Table as HTML.
17. table.RenderControl(hw);
18. //Export the Table to Excel.
19. Response.Clear();
20. Response.Buffer = true;
21. Response.AddHeader("content-disposition", "attachment;filename=Images.xls");
22. Response.Charset = "";
23. Response.ContentType = "application/vnd.ms-excel";
24. //Write the HTML string to Response.
25. Response.Write(sw.ToString());
26. Response.Flush();
27. Response.End();
28. }
29. }
30. }
31. public override void VerifyRenderingInServerForm(Control control)
32. {
33. /* Verifies that the control is rendered */
34. }
35. private string GetAbsoluteUrl(string relativeUrl)
36. {
37. relativeUrl = relativeUrl.Replace("~/", string.Empty);
38. string[] splits = Request.Url.AbsoluteUri.Split('/');
39. if (splits.Length >= 2)
40. {
41. string url = splits[0] + "//";
42. for (int i = 2; i < splits.Length - 1; i++)
43. {
44. url += splits[i];
45. url += "/";
46. }
47. return url + relativeUrl;
48. }
49. return relativeUrl;
50. }

dhoni kholi6y ago

Jack Ponce how to display that image also in excel please help me to solve this problem

Jack Ponce6y ago

dhoni kholi your file still doesn't start with

Have you tried what I previously suggested you do? Unfortunately, somebody deleted my answer...

dhoni kholi6y ago

Jack this is my output

Jack Ponce6y ago

dhoni kholi can you upload the "FileName.xls" file that you get?

I'm getting the following:

Of course, the embedded base64 image is ignored because MS Excel doesn't support it.

dhoni kholi6y ago

Same problem is also coming excel output is same as above image

Rajeesh Menoth6y ago

Hi,

Try the following threads that have already solved.

https://stackoverflow.com/questions/1211001/export-page-which-include-images-to-excel

https://forums.asp.net/t/1903453.aspx?Export+the+picture+into+Excel+including+GridView