导出数据到Excel
protected void btnExportOut_Click(object sender, EventArgs e) { try { DataTable exportData = new DataTable(); exportData.Columns.Add("主叫号码", typeof(string)); exportData.Columns.Add("被叫号码", typeof(string)); exportData.Columns.Add("接听时间", typeof(string)); exportData.Columns.Add("呼叫类型", typeof(string)); exportData.Columns.Add("工作单类型", typeof(string)); exportData.Columns.Add("地址", typeof(string)); exportData.Columns.Add("座席员", typeof(string)); exportData.Columns.Add("来电内容", typeof(string)); exportData.Columns.Add("解决方案", typeof(string)); string SqlWhere = " 1=1 "; StandardData dataObjectWorkCard = new StandardData("WorkCard"); DataTable dtWorkCard = dataObjectWorkCard.GetDataTable(-1, -1, SqlWhere, "", "*"); foreach (DataRow dr in dtWorkCard.Rows) { DataRow newRow = exportData.NewRow(); newRow["主叫号码"] = dr["CallerID"].ToString(); newRow["被叫号码"] = dr["CalledID"].ToString(); newRow["接听时间"] = dr["TimeStamp"].ToString(); newRow["呼叫类型"] = dr["Type"].ToString(); newRow["工作单类型"] = dr["WorkCardType"].ToString(); newRow["地址"] = dr["Address"].ToString(); newRow["座席员"] = dr["OperatorName"].ToString(); newRow["来电内容"] = dr["Memo"].ToString(); newRow["解决方案"] = dr["Process"].ToString(); exportData.Rows.Add(newRow); } WX.Utils.Office.ExportExcel(Page, exportData, this.Response, ""); ShowMessage("导出成功!"); } catch (Exception ex) { WX.EntLib_Base.ExceptionManager.WebExceptionManager.ProcessException(this, ex); ShowMessage("导出失败!"); } }