AspBucket offers ASP.NET, C#, VB, Jquery, CSS, Ajax, SQL tutorials. It is the best place for programmers to learn

Wednesday 2 March 2016

Export excel file on button click in

In this article I will discuss how to export excel file in On click download button excel file will download. Please check below code.

<asp:LinkButton ID="lnkGenerateReport" runat="server" ToolTip="Download Report" CssClass="btn btn-default btn-xs pull-right" OnClick="lnkGenerateReport_Click">  <i class="fa fa-download"></i></asp:LinkButton>

Add new report entity class
 public Class ReportDataEntity()
     public string Name{get;set;}
     public int StandardOfferCount{get;set;}
     public int ProductOfferCount{get;set;}

Generate Excel report code:
 #region--Generate Excel--
    protected void lnkGenerateReport_Click(object sender, EventArgs e)
        Response.Buffer = true;
        Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "ToDaysOfferAddedReport"+DateTime.Now.ToString("dd_MM_yyyy_hh_mm_ss") + ".xls"));
        Response.ContentType = "application/ms-excel";
        List<ReportDataEntity> Report = GetOfferData(); // Write your logic to fetch data
        string str = string.Empty;
        Response.Write(str + "Name");
        str = "\t";
        Response.Write(str + "Standard Offer Count");
        str = "\t";
        Response.Write(str + "Product Offer Count");
        str = "\t";
        foreach (ReportDataEntity dr in Report)
            str = "";            
            Response.Write(str + Convert.ToString(dr.MerchantName));
            str = "\t";
            Response.Write(str + Convert.ToString(dr.StandardOfferCount));
            str = "\t";
            Response.Write(str + Convert.ToString(dr.ProductOfferCount));
            str = "\t";

On click download report button browser will alert excel file.


Post a Comment

  • Popular Posts
  • Comments