如何生成Excel工作表标题列名称并绑定到数据集，如A，B，C，AA，BB [英] how to generate excel sheet Header column names and bind to dataset like A,B,C,AA,BB

问题描述

如何生成Excel工作表标题列名并绑定到数据集，如A，B，C，AA，BB 

解决方案

嗨...

这里将标题列名称绑定到数据库中的excel表格（导出到excel表格）。只有数据库表格的标题列



protected void导出（对象发送者，EventArgs e）

{

con = new MySqlConnection（cs）;

cmd = new MySqlCommand（select * from tablename，con）;

cmd.ExecuteNonQuery（）;

da = new MySqlDataAdapter（cmd）;

DataTable dt = new DataTable（）;

da.Fill（dt）;



string filename = Server.MapPath（〜/ Download.xls）;

StreamWriter sw = new StreamWriter（filename，false）;



int iColCount = dt.Columns.Count;

for（int i = 1; i< iColCount; i ++）

{

sw.Write（ dt.Columns [i]）;

if（i< iColCount - 1）

{

sw.Write（，） ;

}

}

sw.Write（sw.NewLine）;



foreach（DataRow dr in dt.Rows）

{

sw.Write（sw.NewLine）;

}

sw.Close（）;

Response.ClearContent（）;

Response.ContentType =" application / xls" ;;

Response.AddHeader（" Content-Disposition" ;，attachment; filename = Download.xls"）;

Response.WriteFile（filename）;

Response.Flush（）;

//Response.Write（）;

Response.End（）;

}



谢谢你

how to generate excel sheet Header column names and bind to dataset like A,B,C,AA,BB

解决方案

Hi...
Here bind header columns name to excel sheet from database(Export to excel sheet).Only header columns of the table from database

protected void Export(object sender, EventArgs e)
{
con = new MySqlConnection(cs);
cmd = new MySqlCommand("select * from tablename", con);
cmd.ExecuteNonQuery();
da = new MySqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

string filename = Server.MapPath("~/Download.xls");
StreamWriter sw = new StreamWriter(filename, false);

int iColCount = dt.Columns.Count;
for (int i = 1; i < iColCount; i++)
{
sw.Write(dt.Columns[i]);
if (i < iColCount - 1)
{
sw.Write(",");
}
}
sw.Write(sw.NewLine);

foreach (DataRow dr in dt.Rows)
{
sw.Write(sw.NewLine);
}
sw.Close();
Response.ClearContent();
Response.ContentType = "application/xls";
Response.AddHeader("Content-Disposition","attachment; filename=Download.xls");
Response.WriteFile(filename);
Response.Flush();
//Response.Write();
Response.End();
}

thank u.

这篇关于如何生成Excel工作表标题列名称并绑定到数据集，如A，B，C，AA，BB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！