为了账号安全,请及时绑定邮箱和手机立即绑定

如何导出到Excel?

如何导出到Excel?

ITMISS 2019-10-22 21:14:02
我遵循了本指南,该指南是另一篇关于此指南的建议,但我无法完全使它起作用。我尝试重定向到/ LogModelsController / ExportData时收到404错误,据我所知,这正是我应该做的。_LogPartialLayout.cshtml@using (Html.BeginForm("ExportData", "LogModelsController", FormMethod.Post, new { enctype = "multipart/form-data" })){    <table class="table">        <tr>            <th>                @Html.ActionLink("message", "Index", new { sortOrder = ViewBag.NameSortParm, currentFilter = ViewBag.CurrentFilter })            </th>            <th>                @Html.ActionLink("timestamp", "Index", new { sortOrder = ViewBag.NameSortParm, currentFilter = ViewBag.CurrentFilter })            </th>            <th>                @Html.ActionLink("level", "Index", new { sortOrder = ViewBag.NameSortParm, currentFilter = ViewBag.CurrentFilter })            </th>        </tr>        @foreach (var item in Model)        {            <tr>                <td>                    @Html.DisplayFor(modelItem => item.message)                </td>                <td>                    @Html.DisplayFor(modelItem => item.timeStamp)                </td>                <td>                    @Html.DisplayFor(modelItem => item.level)                </td>            </tr>        }    </table>    <input type="submit" name="Export" id="Export" value="Export" />}LogModelsController.cspublic ActionResult ExportData()        {            GridView gv = new GridView();            gv.DataSource = db.Log.ToList();            gv.DataBind();            Response.ClearContent();            Response.Buffer = true;            Response.AddHeader("content-disposition", "attachment; filename=Loglist.xls");            Response.ContentType = "application/ms-excel";            Response.Charset = "";            StringWriter sw = new StringWriter();            HtmlTextWriter htw = new HtmlTextWriter(sw);            gv.RenderControl(htw);            Response.Output.Write(sw.ToString());            Response.Flush();TD; DR:如何正确将此表导出到Excel?奖励:它也可以与PagedList一起使用吗?
查看完整描述

3 回答

  • 3 回答
  • 0 关注
  • 414 浏览

添加回答

举报

0/150
提交
取消
意见反馈 帮助中心 APP下载
官方微信