In this article I will explain with an example, how to export Grid (Html Table) data from database to Word file in ASP.Net Core Razor Pages.
The Grid (Html Table) will be populated from database using Entity Framework and then the records from the database will be exported and downloaded as Word file in ASP.Net Core Razor Pages.
 
 
Database
Here I am making use of Microsoft’s Northwind Database. You can download it from here.
Download and install Northwind Database
 
 
Namespaces
You need to import the following namespace.
using System.Text;
 
 
Model
The Model class consists of the following four properties.
public class Customer
{
    public string CustomerID { get; set; }
    public string ContactName { get; set; }
    public string City { get; set; }
    public string Country { get; set; }
}
 
 
Database Context
Once the Entity Framework is configured and connected to the database table, the Database Context will look as shown below.
Note: For beginners in ASP.Net Core and Entity Framework, please refer my article ASP.Net Core Razor Pages: Simple Entity Framework Tutorial with example. It covers all the information needed for connecting and configuring Entity Framework with ASP.Net Core.
 
using Microsoft.EntityFrameworkCore;
 
namespace Export_Word_Razor_Core
{
    public class DBCtx : DbContext
    {
        public DBCtx(DbContextOptions<DBCtx> options) : base(options)
        {
           
        }
       
        public DbSet<Customer> Customers { get; set; }
    }
}
 
 
Razor PageModel (Code-Behind)
The PageModel consists of following two Handler methods.
Handler method for handling GET operation
Inside this Handler method, the Top 10 records are fetched from the Customers table using Entity Framework and assigned to the public property Customers and returned to the Razor Page.
 
Handler method for handling the Word File Export and Download operation
This Handler method is executed when the Export button is clicked.
Note: The following Handler method performs File Download operation. Hence the return type is set to FileResult.
 
The HTML of the Grid sent from the Razor Page is extracted from the GridHtml parameter and converted to Byte Array using the GetBytes method of Encoding class.
Finally, using the File function the Byte Array object is exported and downloaded as Word file.
public class IndexModel : PageModel
{
    private DBCtx Context { get; }
 
    public IndexModel(DBCtx _context)
    {
        this.Context = _context;
    }
 
    public List<Customer> Customers { get; set; }
 
    public void OnGet()
    {
        this.Customers = this.Context.Customers.Take(10).ToList();
    }
 
    public FileResult OnPostExport(string GridHtml)
    {
        byte[] bytes = Encoding.UTF8.GetBytes(GridHtml);
        return File(bytes, "application/vnd.ms-word", "Grid.doc");
    }
}
 
 
Razor Page (HTML)
Displaying the Records
For displaying the records, an HTML Table is used. A loop will be executed over the Model which will generate the HTML Table rows with the Customer records.
 
Exporting HTML Table to Word Document
Below the HTML Table there is an HTML Form within which a Hidden Field and a Submit Button has been placed.
The Export Button has been set with the POST Handler method using the asp-page-handler attribute.
Note: In the Razor PageModel, the Handler method name is OnPostExport but here it will be specified as Export when calling from the Razor HTML Page.
 
The Hidden Field element is used to send the Grid HTML content to the Handler method.
When the Export Button is clicked, first the HTML of the Grid (Html Table) is extracted and set into the Hidden Field element and finally, the Form is submitted.
@page
@model Export_Word_Razor_Core.Pages.IndexModel
@addTagHelper*, Microsoft.AspNetCore.Mvc.TagHelpers
 
@{
    Layout = null;
}
 
<!DOCTYPE html>
 
<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
</head>
<body>
    <h4>Customers</h4>
    <hr/>
    <div id="Grid">
        <table cellpadding="5" cellspacing="0" style="border: 1pxsolid #ccc;font-size: 9pt;font-family:Arial">
            <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 (var customer in Model.Customers)
            {
                <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 method="post">
        <input type="hidden" name="GridHtml" />
        <input type="submit" id="btnSubmit" value="Export" asp-page-handler="Export" />
    </form>
    <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>
</body>
</html>
 
 
Screenshots
Grid (Html Table)
ASP.Net Core Razor Pages: Export Grid (Html Table) data from database to Word
 
Exported Word File
ASP.Net Core Razor Pages: Export Grid (Html Table) data from database to Word
 
 
Downloads
Download Code