public void CreateExcell(String FileName)
{
dt = Companyinfo.GetList(""); //DataTable获取
System.Web.UI.WebControls.DataGrid dataGrid = new System.Web.UI.WebControls.DataGrid();
dataGrid.DataSource = dt.DefaultView;
dataGrid.AllowPaging = false;
dataGrid.HeaderStyle.BackColor = System.Drawing.Color.Green;
dataGrid.HeaderStyle.Font.Bold = true;
dataGrid.DataBind();
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
dataGrid.RenderControl(hw); string filePath = ConfigurationManager.AppSettings["SaveExcellFile"].ToString() + FileName;
System.IO.StreamWriter sw = System.IO.File.CreateText(filePath);
sw.Write(tw.ToString()); //创建可写入
sw.Close();}//PS : 不能在此函中使用 页面Page对象,即 page.Response;
{
dt = Companyinfo.GetList(""); //DataTable获取
System.Web.UI.WebControls.DataGrid dataGrid = new System.Web.UI.WebControls.DataGrid();
dataGrid.DataSource = dt.DefaultView;
dataGrid.AllowPaging = false;
dataGrid.HeaderStyle.BackColor = System.Drawing.Color.Green;
dataGrid.HeaderStyle.Font.Bold = true;
dataGrid.DataBind();
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
dataGrid.RenderControl(hw); string filePath = ConfigurationManager.AppSettings["SaveExcellFile"].ToString() + FileName;
System.IO.StreamWriter sw = System.IO.File.CreateText(filePath);
sw.Write(tw.ToString()); //创建可写入
sw.Close();}//PS : 不能在此函中使用 页面Page对象,即 page.Response;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货