手动导出Excel方法
private void dgJiBingZhenDuanBind()
{
Response.Clear();
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("柘荣县医院住院病历" + DateTime.Now.ToShortDateString() + ".xls", Encoding.UTF8)); this.EnableViewState = false;
StringBuilder sbHtml = new StringBuilder();
sbHtml.Append("<table border='1'>");
sbHtml.Append("<tr>");
sbHtml.Append("<td>住院号</td>");
sbHtml.Append("<td>姓名</td>");
sbHtml.Append("<td>性别</td>");
// sbHtml.Append("<td>床位号</td>");
sbHtml.Append("<td>出生日期</td>");
//sbHtml.Append("<td>职业</td>");
// sbHtml.Append("<td>地址</td>");
sbHtml.Append("<td>入院时间</td>");
sbHtml.Append("<td>入院诊断</td>");
sbHtml.Append("<td>出院时间</td>");
sbHtml.Append("<td>出院诊断</td>");
sbHtml.Append("<td>医生</td>");
sbHtml.Append("</tr>");
DataTable dt = Session["BingLiChaXun"] as DataTable;
if (CanShuPanDuan.ShiFouKong(dt, 1))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "<script language='javascript'>yanshitishi('系统提示:打印暂无数据,请先进行查询!','2')</script>");
return;
}
//逐行处理数据
foreach (DataRow row in dt.Rows)
{
sbHtml.Append("<tr>");
sbHtml.Append("<td>" + row["ZHUYUANHAO"].ToString() + "</td>");
sbHtml.Append("<td>" + row["XINGMING"].ToString() + "</td>");
sbHtml.Append("<td>" + row["XINGBIE"].ToString() + "</td>");
//sbHtml.Append("<td>" + row["chuanghao"].ToString() + "</td>");
sbHtml.Append("<td>" + row["newnianling"].ToString() + "</td>"); // 杨磊
//sbHtml.Append("<td>" + row["zhiye"].ToString() + "</td>");
//sbHtml.Append("<td>" + row["hukoudizhi"].ToString() + "</td>");
sbHtml.Append("<td>" + row["RUYUANSHIJIAN"].ToString() + "</td>");
sbHtml.Append("<td>" + row["ruyuanzhenduan1"].ToString() + "</td>");
sbHtml.Append("<td>" + row["CHUYUANSHIJIAN"].ToString() + " </td>");
sbHtml.Append("<td>" + row["chuyuanzhenduan1"].ToString() + "</td>");
sbHtml.Append("<td>" + row["yisheng"].ToString() + "</td>");
sbHtml.Append("</tr>");
}
sbHtml.Append("</table>");
Response.Write("<meta http-equiv=Content-Type content=text/html;charset=gb2312>");
Response.Write(sbHtml.ToString());
Response.End();
}