OpenXml Articles

Category - OpenXml

Follow @ASPSnippets

18 Jul 2017 Mudassar Khan 0 Comments 1338 Views

ASP.Net Excel OpenXml ClosedXml MVC

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.

15 Oct 2015 Mudassar Khan 3 Comments 33088 Views

ASP.Net Excel GridView OpenXml

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.

15 Oct 2015 Mudassar Khan 0 Comments 17209 Views

ASP.Net Excel GridView OpenXml

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.

15 Oct 2015 Mudassar Khan 5 Comments 12662 Views

Issues and Exceptions OpenXml

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.