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);
}
