OpenXml Articles

Category - OpenXml

18 Jul 2017 Mudassar Khan 0 Comments 4452 Views

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 40609 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 22211 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 6 Comments 15857 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.