从sql数据创建.xlsx文件 [英] creating .xlsx file fro sql data
本文介绍了从sql数据创建.xlsx文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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();
}
}
.xls文件可以轻松创建这段代码,但每当我将扩展名更改为.xlsx时,文件就无法在excel 2007中打开。请指出错误并建议我使用相同的编码。
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..
推荐答案
请点击链接
将Gridview数据导出到ASP.NET中的Excel [ ^ ]
更改为.xlsx取代.xls。
谢谢
Please follow the link
Export Gridview Data to Excel in ASP.NET[^]
Change to .xlsx in place of .xls.
Thanks
这篇关于从sql数据创建.xlsx文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文