下面的lstTitle必须与要导出的数据表字段一一对应
根据个人项目不同,可使用方法,稍微修改就能成为自己的。
这里在后台使用拼接一个table,然后返回到web界面,一个路径的指向就相当于下载保存到本地。(个人理解,见笑/哈哈)
/// <summary>
/// 导出excel
/// 作者:刘建超 2017.10.27
/// </summary>
/// <returns></returns>
public ActionResult LeadOut()
{
var query = ExcelList.ExcelList;//这里放入查询得到的List<Model>
var sbHtml = new StringBuilder();
sbHtml.Append("<table border='1' cellspacing='0' cellpadding='0'>");
sbHtml.Append("<tr>");
var lstTitle = new List<string> { "年份","员工编号", "中文名"};
foreach (var columnName in lstTitle)
{
sbHtml.AppendFormat(" <td style='font-size: 14px;text-align:center;background-color: #DCE0E2; font-weight:bold;' height='25'>{0}</td>", columnName);
}
sbHtml.Append("</tr>");
string tdHtml = "<td style='font-size: 12px;height:20px;'>{0}</td>";
if (query != null && query.Count > 0)
{
foreach (var row in query)
{
sbHtml.Append("<tr>");
sbHtml.AppendFormat(tdHtml, row.Year);
sbHtml.AppendFormat(tdHtml, row.EmployeeNo);
sbHtml.AppendFormat(tdHtml, row.Name);
sbHtml.Append("</tr>");
}
sbHtml.Append("</table>");
}
else
{
return null;
}
string filename = System.IO.Path.Combine(DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
string HTMLStr = string.Format("<html><head><meta http-equiv=Content-Type content=\"text/html; charset=utf-8\"></head><body>{0}</body></html>", sbHtml.ToString());
byte[] fileContents = Encoding.UTF8.GetBytes(HTMLStr);
return File(fileContents, "application/ms-excel", filename);
}
前台页面很简单
<input type="button" value="导出Excel" class="ownDefined" οnclick="LeadOut()" />
//导出
function LeadOut() {
location.href = "@Url.Action("LeadOut", "CCManagerInfo")";
}
根据个人项目不同,可使用方法,稍微修改就能成为自己的。
这里在后台使用拼接一个table,然后返回到web界面,一个路径的指向就相当于下载保存到本地。(个人理解,见笑/哈哈)
/// <summary>
/// 导出excel
/// 作者:刘建超 2017.10.27
/// </summary>
/// <returns></returns>
public ActionResult LeadOut()
{
var query = ExcelList.ExcelList;//这里放入查询得到的List<Model>
var sbHtml = new StringBuilder();
sbHtml.Append("<table border='1' cellspacing='0' cellpadding='0'>");
sbHtml.Append("<tr>");
var lstTitle = new List<string> { "年份","员工编号", "中文名"};
foreach (var columnName in lstTitle)
{
sbHtml.AppendFormat(" <td style='font-size: 14px;text-align:center;background-color: #DCE0E2; font-weight:bold;' height='25'>{0}</td>", columnName);
}
sbHtml.Append("</tr>");
string tdHtml = "<td style='font-size: 12px;height:20px;'>{0}</td>";
if (query != null && query.Count > 0)
{
foreach (var row in query)
{
sbHtml.Append("<tr>");
sbHtml.AppendFormat(tdHtml, row.Year);
sbHtml.AppendFormat(tdHtml, row.EmployeeNo);
sbHtml.AppendFormat(tdHtml, row.Name);
sbHtml.Append("</tr>");
}
sbHtml.Append("</table>");
}
else
{
return null;
}
string filename = System.IO.Path.Combine(DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
string HTMLStr = string.Format("<html><head><meta http-equiv=Content-Type content=\"text/html; charset=utf-8\"></head><body>{0}</body></html>", sbHtml.ToString());
byte[] fileContents = Encoding.UTF8.GetBytes(HTMLStr);
return File(fileContents, "application/ms-excel", filename);
}
前台页面很简单
<input type="button" value="导出Excel" class="ownDefined" οnclick="LeadOut()" />
//导出
function LeadOut() {
location.href = "@Url.Action("LeadOut", "CCManagerInfo")";
}