//前端按钮请求
function Out_Excel(TC_ID) {
$.post("Ajax/ExportExcel.aspx", { TC_ID: TC_ID }, function (data) {
if (data != "") { window.open(data); }
})
}
///后端接口处理using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using Model;using BLL;using System.IO;
namespace CRM系统.Ajax{ public partial class ExportExcel : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { int TC_ID = Convert.ToInt32(Request["TC_ID"]); List<Out_Excel> stuList =StudentsBLL.GetstudentsAndTrainClassStudents(TC_ID);
//创建Excel文件的对象 NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
//添加一个sheet NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");
//添加标题 NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0); row1.CreateCell(0).SetCellValue("原校区"); row1.CreateCell(1).SetCellValue("原班级"); row1.CreateCell(2).SetCellValue("现班级"); row1.CreateCell(3).SetCellValue("校区代码"); row1.CreateCell(4).SetCellValue("序号"); row1.CreateCell(5).SetCellValue("学号"); row1.CreateCell(6).SetCellValue("姓名"); row1.CreateCell(7).SetCellValue("姓名拼音"); row1.CreateCell(8).SetCellValue("性别"); row1.CreateCell(9).SetCellValue("身份证号"); row1.CreateCell(10).SetCellValue("班级编号"); row1.CreateCell(11).SetCellValue("学生状态"); row1.CreateCell(12).SetCellValue("已通过认证"); row1.CreateCell(13).SetCellValue("学历"); row1.CreateCell(14).SetCellValue("专业"); row1.CreateCell(15).SetCellValue("毕业学校"); row1.CreateCell(16).SetCellValue("个人手机"); row1.CreateCell(17).SetCellValue("家庭座机"); row1.CreateCell(18).SetCellValue("QQ号"); row1.CreateCell(19).SetCellValue("通信地址"); row1.CreateCell(20).SetCellValue("邮编"); row1.CreateCell(21).SetCellValue("技术评价"); row1.CreateCell(22).SetCellValue("班主任评价"); row1.CreateCell(23).SetCellValue("备注");
for (int i = 0; i < stuList.Count; i++) { NPOI.SS.UserModel.IRow stuRows = sheet1.CreateRow(i + 1); stuRows.CreateCell(0).SetCellValue(stuList[i].School_Name); stuRows.CreateCell(1).SetCellValue(stuList[i].SC_Name); stuRows.CreateCell(2).SetCellValue(stuList[i].TC_Name); stuRows.CreateCell(3).SetCellValue(stuList[i].School_Code); stuRows.CreateCell(4).SetCellValue(i + 1); stuRows.CreateCell(5).SetCellValue(stuList[i].Student_NO); stuRows.CreateCell(6).SetCellValue(stuList[i].Student_Name); stuRows.CreateCell(7).SetCellValue(stuList[i].Student_NameSpell); stuRows.CreateCell(8).SetCellValue(stuList[i].Student_Sex); stuRows.CreateCell(9).SetCellValue(stuList[i].Student_IdentityNumber); stuRows.CreateCell(10).SetCellValue(stuList[i].SC_ID.ToString()); stuRows.CreateCell(11).SetCellValue(stuList[i].Student_State); stuRows.CreateCell(12).SetCellValue(stuList[i].Student_Exam); stuRows.CreateCell(13).SetCellValue(stuList[i].Student_Education); stuRows.CreateCell(14).SetCellValue(stuList[i].Student_Specialty); stuRows.CreateCell(15).SetCellValue(stuList[i].Student_Schoolofgraduation); stuRows.CreateCell(16).SetCellValue(stuList[i].Student_PersonalTel); stuRows.CreateCell(17).SetCellValue(stuList[i].Student_FamilyTel); stuRows.CreateCell(18).SetCellValue(stuList[i].Student_QQ); stuRows.CreateCell(19).SetCellValue(stuList[i].Student_Address); stuRows.CreateCell(20).SetCellValue(stuList[i].Student_PostCode); stuRows.CreateCell(21).SetCellValue(stuList[i].Student_Evaluate1); stuRows.CreateCell(22).SetCellValue(stuList[i].Student_Evaluate2); stuRows.CreateCell(23).SetCellValue(stuList[i].Student_Remark); }
FileStream fs = new FileStream(Server.MapPath("..\\创建的文件夹名\\" + stuList.Count + ".xls"), FileMode.Create); book.Write(fs); fs.Close(); Response.Write("..\\创建的文件夹名\\" + stuList.Count + ".xls"); } }}
导入 NPOI文件找到 NPOI文件导入到bin目录下然后引用
转载于:https://www.cnblogs.com/yjm8023/p/9295995.html
相关资源：数据结构—成绩单生成器