Export HTML Table to Word file in ASP.Net Core MVC

Last Reply one month ago By dharmendr

Posted one month ago

How to export HTML table data to word document in ASP.Net Core MVC

Posted one month ago

Hi rani,

Check this example. Now please take its reference and correct your code.

For exporting to word you need to install sautinsoft.document library from nuget.

Refer below link.

sautinsoft.document

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

Model

public class Customer
{
    public string CustomerID { get; set; }
    public string ContactName { get; set; }
    public string City { get; set; }
    public string Country { get; set; }
}

Namespaces

using System.IO;
using SautinSoft.Document;

Controller

public class HomeController : Controller
{
    private IHostingEnvironment Environment;
    private DBCtx Context { get; }
    public HomeController(DBCtx _context, IHostingEnvironment _environment)
    {
        this.Context = _context;
        Environment = _environment;
    }

    public IActionResult Index()
    {
        return View(this.Context.Customers.Take(10).ToList());
    }

    [HttpPost]
    public IActionResult Export(string GridHtml)
    {
        string path = Path.Combine(this.Environment.WebRootPath, "HTML");
        if (!Directory.Exists(path))
        {
            Directory.CreateDirectory(path);
        }

        string input = Path.Combine(path, "html1.html");
        string output = Path.Combine(path, "Grid.docx");
        System.IO.File.WriteAllText(input, GridHtml);
        DocumentCore documentCore = DocumentCore.Load(input);
        documentCore.Save(output);
        byte[] bytes = System.IO.File.ReadAllBytes(output);

        Directory.Delete(path, true);

        return File(bytes, "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "Grid.docx");
    }
}

View

@addTagHelper*, Microsoft.AspNetCore.Mvc.TagHelpers
@using Export_Table_Word_Core_MVC.Models
@model IEnumerable<Customer>

@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
    <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
    <script type="text/javascript">
        $(function () {
            $(".btnSubmit").click(function () {
                $("input[name='GridHtml']").val($("#Grid").html());
            });
        });
    </script>
</head>
<body>
    <h4>Customers</h4>
    <hr />
    <div id="Grid">
        <table cellpadding="5" cellspacing="0" style="border: 1px solid #ccc;font-size: 9pt;">
            <tr>
                <th style="background-color: #B8DBFD;border: 1px solid #ccc">CustomerID</th>
                <th style="background-color: #B8DBFD;border: 1px solid #ccc">ContactName</th>
                <th style="background-color: #B8DBFD;border: 1px solid #ccc">City</th>
                <th style="background-color: #B8DBFD;border: 1px solid #ccc">Country</th>
            </tr>
            @foreach (Customer customer in Model)
            {
                <tr>
                    <td style="width:120px;border: 1px solid #ccc">@customer.CustomerID</td>
                    <td style="width:120px;border: 1px solid #ccc">@customer.ContactName</td>
                    <td style="width:120px;border: 1px solid #ccc">@customer.City</td>
                    <td style="width:120px;border: 1px solid #ccc">@customer.Country</td>
                </tr>
            }
        </table>
    </div>
    <br />
    <br />
    <form asp-action="Export" asp-controller="Home" method="post">
        <input type="hidden" name="GridHtml" />
        <input type="submit" value="Export" class="btnSubmit" />/>
    </form>
</body>
</html>

Screenshots

HTML Table

Exported Word File