protected void btn_Click(object sender, EventArgs e) { DataTable dt = NPOI_EXCEL.getDataTable(FileUpload1); grid.DataSource = dt; grid.DataBind(); }
protected void btnDownLoad_Click(object sender, EventArgs e) { string FN = "Student.xls";//模板名 NPOI_EXCEL.DownLoad(FN); Page_Load(sender, e); }
protected void Button2_Click(object sender, EventArgs e) { // DataTable dt = new DataTable(); // Bind(dt); string sql = "select StuID as '学号',StuName as '姓名',Class as '班级',Program as '活动',Working_hours as '工时',SySe as '学期',Date as '日期' from Working_hours where Program ='" + Session["Program"] + "' and SySe ='" + Session["SySe"] + "'"; DataTable dt = Common.datatable(sql); gridview.DataSource = dt; // NPOItest.Batch_Update(dt); // NPOIHelper.ExportByWeb(dt, GridView1.Caption, GridView1.Caption); // NPOIHelper.ExportByWeb(dt, gridview.Caption, gridview.Caption); NPOI_EXCEL.ExportByWeb(dt, gridview.Caption); }
protected void DownLoad_Click(object sender, EventArgs e) { string fn = "Working_hours.xlsx"; NPOI_EXCEL.DownLoad(fn); }