public ActionResult RenderToExcel(PubPage fg)
{
string sql = "select Telephone,Pwd from SystemUser";
var dt = _iSysUserServices.ToDataTable(sql, null);
string[] Telephone = { "手机号", "密码" };
for (int i = 0; i < dt.Columns.Count; i++)
{
dt.Columns[i].ColumnName = Telephone[i];
}
var ms = NpoiHelper.RenderToExcel(dt);
var xlsx = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
var xls = "application/vnd.ms-excel";
return(File(ms, xls, "用户信息" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls"));
}
