首页 > 代码库 > 获取数据后导出Excel
获取数据后导出Excel
List<PortResourceInfo> list = getList()//获取数据源
//导出excle
Response.Clear();
Response.ContentType = "application/excel";
Response.AddHeader("Content-Disposition", "inline;filename=" + HttpUtility.UrlEncode("端口资源.xls", Encoding.UTF8));
StringBuilder expStr = new StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(expStr);
expStr.Append("<html><body>");
expStr.Append("<table><tr><th>序号</th><th>设备名称</th><th>设备型号</th><th>设备IP</th><th>端口名称</th><th>端口描述</th><th>端口带宽</th><th>Up/Down</th><th>端口状态</th></tr>");
int i = 1;
foreach (var item in list)
{
expStr.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><td>{7}</td><td>{8}</td></tr>",
i, item.DeviceName, item.DiveceType,
item.IpAddress, item.IfName, item.Description,
item.IfSpeed, item.UpOrDown, item.IsFree
);
i++;
}
expStr.Append("</table></body></html>");
Page.EnableViewState = false;
Response.Write(sw.ToString());
Response.End();
获取数据后导出Excel