Category - ClosedXml
Results 6 - 10 of 14
01 Jun 2018 01 Jun 2018 0 Comments  23829 Views
Here Mudassar Ahmed Khan has explained with an example, how to export DataGridView data to Excel file with formatting i.e. Colors and Styles in Windows Forms (WinForms) Applications using C# and VB.Net.

DataGridView cannot be exported directly to Excel file and hence need to generate a DataTable and export the DataTable to Excel file.

The DataTable will be exported to a formatted Excel file using ClosedXml library which is a wrapper of OpenXml.
31 May 2018 31 May 2018 0 Comments  11310 Views
Here Mudassar Ahmed Khan has explained with an example, how to read and import Excel file data to DataGridView using ClosedXml using C# and VB.Net in Windows Forms (Winforms) Application.
18 Jul 2017 18 Jul 2017 0 Comments  12291 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.
18 Jul 2017 18 Jul 2017 1 Comments  28595 Views
Here Mudassar Ahmed Khan has explained with an example, how to used ClosedXML library in ASP.Net MVC Razor.

This article will also explain how to use ClosedXML library to export DataTable (DataSet) to Excel file in ASP.Net MVC Razor.

The data from the database is fetched using Entity Framework and then it is used to populate a DataTable.

Then the DataTable is exported and downloaded as Microsoft Excel file using ClosedXML Excel Library which is a wrapper for OpenXml Excel library.
18 Jul 2017 18 Jul 2017 0 Comments  27007 Views
Here Mudassar Ahmed Khan has explained with an example, how to export DataTable (DataSet) to Excel file in ASP.Net MVC Razor.

The data from the database is fetched using Entity Framework and then it is used to populate a DataTable.

Then the DataTable is exported and downloaded as Microsoft Excel file using ClosedXML Excel Library which is a wrapper for OpenXml Excel library.
Results 6 - 10 of 14