/// <summary> /// Myxls导出Excel,保存在客户端 /// </summary> private void DataTableExportToExcel(long applyId, string xlsName, string sheetName) { //表头 //决定Datatable显示哪些内容 DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Sheet1"); DataRow dr; DataColumn column; //1---序号 column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "序号"; ds.Tables["Sheet1"].Columns.Add(column); //2---准考证号 column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "准考证号"; ds.Tables["Sheet1"].Columns.Add(column); //3---姓名 column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "姓名"; ds.Tables["Sheet1"].Columns.Add(column); //4---专业 column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "专业"; ds.Tables["Sheet1"].Columns.Add(column); var ml = new BLL.CCOM.Examination_arrangement_detail().GetModelList(" Ea_id='" + applyId + "' order by newid()"); for (int row = 0; row < ml.Count; row++) { var m = ml[row]; //申请人基本信息 //学生用户 try { Model.CCOM.View_UserAgency model = new BLL.CCOM.View_UserAgency().GetModel(" User_id='" + m.User_id + "'"); dr = ds.Tables["Sheet1"].NewRow(); dr[0] = row + 1; dr[1] = model.UP_CCOM_number; dr[2] = model.User_realname; dr[3] = model.Agency_name; ds.Tables["Sheet1"].Rows.Add(dr); } catch { continue; } } //导出EXCEL,速度有点慢 DataToExcel.ExportToExcel(ds, Server.MapPath("/upload/excel/"), xlsName + ".xlsx", this.Page); }
/// <summary> /// Myxls导出Excel,保存在客户端 /// </summary> private void DataTableExportToExcel(string xlsName, string sheetName) { //表头 //决定Datatable显示哪些内容 DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Sheet1"); DataRow dr; DataColumn column; //1---序号 column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "序号"; ds.Tables["Sheet1"].Columns.Add(column); //2---姓名 column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "姓名"; ds.Tables["Sheet1"].Columns.Add(column); //3---学号/工号 column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "联系电话"; ds.Tables["Sheet1"].Columns.Add(column); //4---性别 column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "性别"; ds.Tables["Sheet1"].Columns.Add(column); ////5---省份 //column = new DataColumn(); //column.DataType = System.Type.GetType("System.String"); //column.ColumnName = "省份"; //ds.Tables["Sheet1"].Columns.Add(column); //6---政治面貌 column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "政治面貌"; ds.Tables["Sheet1"].Columns.Add(column); //7---机构 column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "报考方向"; ds.Tables["Sheet1"].Columns.Add(column); var ml = new BLL.CCOM.View_UserAgency().GetModelList(" User_type !=6 " + CombSqlTxt(this.uo_id, this.provence, this.keywords)); for (int row = 0; row < ml.Count; row++) { var m = ml[row]; dr = ds.Tables["Sheet1"].NewRow(); dr[0] = row + 1; dr[1] = m.User_realname; dr[2] = ((Boolean)m.User_gender) == false ? "男" : "女"; dr[3] = GetProvince(Utils.ObjectToStr(m.User_id)); dr[4] = m.User_number; dr[5] = GetNationality(Utils.ObjectToStr(m.User_id)); dr[6] = m.Agency_name; ds.Tables["Sheet1"].Rows.Add(dr); } //导出EXCEL,速度有点慢 DataToExcel.ExportToExcel(ds, Server.MapPath("/upload/excel/"), xlsName + ".xlsx", this.Page); }