Click here to Skip to main content
13,091,996 members (58,021 online)
Rate this:
 
Please Sign up or sign in to vote.
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.xlsx";
        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();
    }
}



the .xls file can be easily created with this code but whenever i change the extension to .xlsx then the file can't be open in excel 2007..please point out the error and suggest me something with the same coding..
Posted 17-Dec-12 22:26pm
Updated 17-Dec-12 22:40pm
digimanus60.6K
v2

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Please follow the link

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

Change to .xlsx in place of .xls.

Thanks
  Permalink  
Comments
vijay cyrus 18-Dec-12 5:25am
   
just by changing the extension to .xlsx it is unable to open the file ....

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web01 | 2.8.170813.1 | Last Updated 18 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100