下面内容内容是关于asp.net将DataSet中的数据导出Execl并提供下载的内容,希望对大家有些帮助。
public void CreateExcel(DataSet ds,string FileName)
{
HttpResponse resp;
resp = Page.Response;
resp.ContentEncoding = System.Text.Encoding.GetEncoding(“GB2312”);
resp.AppendHeader(“Content-Disposition”, “attachment;filename=”+FileName);
string colHeaders= “”, ls_item="";
DataTable dt=ds.Tables[0];
int i=0;
int cl=dt.Columns.Count;
for(i=0;i<cl;i++)
{
{
colHeaders +=dt.Columns[i].Caption.ToString() +“n”;
}
else
{
colHeaders+=dt.Columns[i].Caption.ToString()+“t”;
}
}
resp.Write(colHeaders);
foreach(DataRow row in myRow)
{
for(i=0;i<cl;i++)
{
{
ls_item +=row[i].ToString()+“n”;
}
else
{
ls_item+=row[i].ToString()+“t”;
}
}
resp.Write(ls_item);
ls_item="";
}
resp.End();
}