Click here to Skip to main content
15,891,372 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.IO;


public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ShowData();
        string dbcon = ConfigurationManager.ConnectionStrings["cn"].ToString();
    }
    public override void VerifyRenderingInServerForm(Control control)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //Excel2007.WorkBook workbook = new Excel2007.WorkBook();

        Response.Clear();
        Response.BufferOutput = false;
        string archiveName = "customer.xls";
        Response.ContentType = "application/zip";
        Response.AddHeader("content-disposition", "filename=" + archiveName);
        Response.Charset = "";
      //  workbook.WorkSheets.Add("FirstSheet");
       // workbook.WorkSheets["FirstSheet"].Cells[0, 1].Value = "first";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        GridView1.AllowPaging = false; GridView1.DataBind();
        GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");
        GridView1.RenderControl(htw);
        Response.Write(sw.ToString());
        //workbook.Save(Response.OutputStream);
        Response.End();
    }

    public void ShowData()
    {

        SqlDataAdapter adp = new SqlDataAdapter("select catname,catid,creationdate,pagename from quizcats  ", ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
        DataSet ds = new DataSet();
        adp.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
}
Posted
Updated 17-Dec-12 23:34pm
v3
Comments
vijay cyrus 18-Dec-12 5:34am    
Somebody help me out with this code to create a file with .xlsx extension...this code works nicely to create .xls file....but the file with .xlsx extension can't be opened in the excel application....
Abhishek Pant 18-Dec-12 5:35am    
whats the problem?
vijay cyrus 18-Dec-12 5:39am    
@Abhishek Pant....
I'm not able to create file with extension .xlsx

1 solution

Please follow and try the link

Export Gridview Data to Excel in ASP.NET[^]
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900