C# (CSharp) NpoiHelper.ExportExcel Exemples

Exemple #1

        public ActionResult RenderToExcel2(PubPage fg)
        {
            string sql = "select * from SystemUser";
            var    dt  = _iSysUserServices.ToDataTable(sql, null);

            NpoiHelper.ExportExcel(dt, "用户信息" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls");
            return(Content(""));
            //return File("application/vnd.ms-excel", "用户信息" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls");
        }