导出

    [HttpGet]
    public int Export(string FileName="123")
    {
        var users = user.GetUserInfos();
        var types = type.GetUTypes();
        List<AllModel> list = (from u in users
                              join t in types on u.TId equals t.TId
                              select new AllModel()
                              {
                                  UId = u.UId,
                                  UName = u.UName,
                                  UAge = u.UAge,
                                  TId = u.TId,
                                  TName = t.TName
                              }).ToList();
        string json = JsonConvert.SerializeObject(list);
        DataTable dt = JsonConvert.DeserializeObject<DataTable>(json);
        //参数1 数据源 参数2 xls表头 参数3 xls文件名称
        //ExcelHelper.ExportByWeb(dt,"请假流程数据","db0708lx.xls");
        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.Charset = "UTF-8";
        HttpContext.Current.Response.ContentType = "application/vnd.ms-xls";
        HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + FileName + ".xls");
        StringBuilder table = new StringBuilder();
        table.Append("<table><tr>");
        for (int j = 0; j < dt.Columns.Count; j++)
        {
            table.Append("<td>");
            table.Append(dt.Columns[j].Caption.ToString());//表格的标题
            table.Append("</td>");
        }
        table.Append("</tr>");
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            table.Append("<tr>");
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                table.Append("<td style='vnd.ms-excel.numberformat:@'>");
                table.Append(dt.Rows[i][j].ToString());
                table.Append("</td>");
            }
            table.Append("</tr>");
        }
        table.Append("</table>");
        HttpContext.Current.Response.Write(table);
        HttpContext.Current.Response.End();
        return 1;
    }