Category - OpenXml
Here Mudassar Ahmed Khan has explained with an example, how to use OpenXml library in ASP.Net MVC Razor.

The data from the database is fetched using Entity Framework and then the data is exported and downloaded as Microsoft Excel file using ClosedXML Excel Library which is a wrapper for OpenXml Excel library.
Here Mudassar Ahmed Khan has explained with an example, how to read and import Excel file (Excel sheet) data to DataTable using OpenXml in ASP.Net with C# and VB.Net.
Here Mudassar Ahmed Khan has explained how to read and import Excel file (Excel sheet) data to GridView without using OELDB in ASP.Net using C# and VB.Net.
Since OLEDB is not used, the Excel file (Excel sheet) data will be read and imported to GridView using OpenXml library in ASP.Net using C# and VB.Net.
Here Mudassar Ahmed Khan has explained how to solve the following compilation error:
CS0012: The type 'System.IO.Packaging.Package' is defined in an assembly that is not referenced. You must add a reference to assembly 'WindowsBase, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.
The above error occurs when we use the OpenXml Packaging Library.