public void Export()
{
try
{
List userInfos = new List();
userInfos.Add(new UserInfo() { UserName = “张三”, Age = 10 });
userInfos.Add(new UserInfo() { UserName = “张三”, Age = 10 });
userInfos.Add(new UserInfo() { UserName = “张三”, Age = 10 });
userInfos.Add(new UserInfo() { UserName = “张三”, Age = 10 });
userInfos.Add(new UserInfo() { UserName = “张三”, Age = 10 });
DataTable data = new DataTable();
data.Columns.Add("姓名", typeof(string)); //姓名
data.Columns.Add("年龄", typeof(string)); //年龄
foreach (var item in userInfos)
{
DataRow row = data.NewRow();
row["姓名"] = item.UserName;
row["年龄"] = item.Age;
data.Rows.Add(row);
}
ExportExcel.ExportToHSSFExcelFromDataTable(Response, data, "a", "A");
// ExportExcel.ExportToHSSFExcelFromDataTable(Response, data, "b", "B");
}
catch (Exception ex)
{
throw;
}
}
}