怎样把得到的数据导入到EXCEL表中啊

Question

怎样把得到的数据导入到EXCEL表中啊

Answer 1

StringWriter sw=new StringWriter(); 
DataSet dt;
try
{
sw.WriteLine("姓名发\t发送给\t时间\t001");
for(int i=0;i<dt.tables.row.count;i++)
{
sw.writeline(dt.table[0].rows[i][0]+"\t"+dt.table[0].rows[i][1]+"\t"+dt.table[0].rows[i][2]+"\t")
}
Response.AddHeader("Content-Disposition", "attachment; filename=test.xls"); 
Response.ContentType = "application/ms-excel"; 
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312"); 
Response.Write(sw); 
Response.End(); 
}
catch(Exception ee)
{
throw ee;
}