将数据导出EXCEL

public void OutFile()

{

 string Name = "成绩表";
              DataSet ds = (DataSet)ViewState["ds"];
             string strLine = "学生编号\t学生姓名\t考试时间\t结束时间\t考试分数";
            ExportDataSetToExcel(this.Page, ds, strLine, Name);

} 

       

 

 

///PAGE为操作页面

///DS为数据源

///strLine列名

///输出文件名

#region 从DataSet导出Excel
        public static void ExportDataSetToExcel(Page page, DataSet ds, string strLine, string strFileName)
        {
            if (ds.Tables.Count < 0) return;
            DataTable dt = ds.Tables[0];
            System.IO.StringWriter sw = new System.IO.StringWriter();
            sw.WriteLine(strLine);
            foreach (DataRow dr in dt.Rows)
            {
                strLine = string.Empty;
                foreach (object x in dr.ItemArray)
                {
                    strLine += "\t" + x.ToString();
                }
                strLine = strLine.Substring(1);
                sw.WriteLine(strLine);

            }
            sw.Close();
            page.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlPathEncode(strFileName) + ".xls");
            page.Response.ContentType = "application/ms-excel";//vnd.ms-excel numberformat:@application/ms-excel//设置输出文件类型为excel文件
            page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
            page.Response.Write(sw);
            page.Response.End();

        }
        #endregion