Question

C#窗体应用程序怎么把dataset或者是access数据库中的数据写到excel表里面

C#窗体应用程序怎么把dataset或者是access数据库中的数据写到excel表里面

Answer 1

using System.Text;
using System.IO;

/// <summary>
/// 以下为数据导出代码
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LinkButton5_Click(object sender, EventArgs e)
{
string style = @"<style> .text { mso-number-format:\@; } </script> ";
Response.ClearContent();//清除缓存区内容
Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
Response.AppendHeader("content-disposition", "attachment; filename=MyExcelFile.xls;
Response.ContentType = "myexcel/excel";//设置输出流的类型
StringWriter sw = new StringWriter();//写入流
XhtmlTextWriter xtw = new XhtmlTextWriter(sw);
GridView2.RenderControl(xtw);
Response.Write(style);
Response.Write(sw.ToString());
Response.End();
bind();
}
public override void VerifyRenderingInServerForm(Control control) { }

Answer 2

百度搜 NPOI