导出EXCEL问题,帮忙一下,谢谢!
以下是导出EXCEL代码,问题是我单击一次导出按钮,然后再单击一次导出按钮,第一次导出的数据和第二次的数据都在一个EXCEL中显示出来,我想得到的是再次导出时清除上一次的数据,请问一下如何修改下面的代码,谢谢!
StringBuilder sb = new StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataTable dta = (DataTable)ViewState["Grid"];
dgData.DataSource = dta;
dgData.DataBind();
if (dgData.Items.Count <= 0)
{
Page.RegisterClientScriptBlock("key", "<script>alert('对不起没有数据导出')</script>");
return;
}
this.dgData.RenderControl(hw);
string path = "../Excel/定点医疗机构基础数据统计(全部)" + System.DateTime.Now.ToString("yyyyMMdd") + ".xls";
Response.Clear();
using (StreamWriter swr = new StreamWriter(Server.MapPath(path), true))
{
swr.WriteLine("<center>");
swr.WriteLine("定点医疗机构基础数据统计<br/>");
string SelCondition = " 所属区县:" + cboFeeArea.SelectedItem.Text + " 统计年月:" + txtQueryNY.Text + " 医疗类别:门诊、住院、门特、其它、住院类" + " 经营性质:" + cboMngType.SelectedItem.Text + "<br/>";
swr.WriteLine(SelCondition);
SelCondition = " 医院等级:" + cboHosLevel.SelectedItem.Text + " 医院类别:" + cboHosType.SelectedItem.Text + " 城镇人群:" + cboPopType.SelectedItem.Text + " 医院代码:" + txtHosCode.Text + "<br/>";
swr.WriteLine(SelCondition);
swr.WriteLine(sb.ToString());
swr.WriteLine("</center>");
swr.Flush();
swr.Close();
swr.Dispose();
}
Response.Redirect(path);