[HttpGet]
public int Export(string FileName=“123”)
{
var users = user.GetUserInfos();
var types = type.GetUTypes();
List 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(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("
for (int j = 0; j < dt.Columns.Count; j++)
{
table.Append("");
}
table.Append("");
for (int i = 0; i < dt.Rows.Count; i++)
{
table.Append("");
for (int j = 0; j < dt.Columns.Count; j++)
{
table.Append("");
}
table.Append("");
}
table.Append("
"); table.Append(dt.Columns[j].Caption.ToString());//表格的标题 table.Append(" |
"); table.Append(dt.Rows[i][j].ToString()); table.Append(" |
HttpContext.Current.Response.Write(table);
HttpContext.Current.Response.End();
return 1;
}