Category - ClosedXml
08 May 2020 08 May 2020 0 Comments  15991 Views
Here Mudassar Ahmed Khan has explained with an example, how to read Excel File (xls & xlsx) data in ASP.Net using C# and VB.Net.

When the Excel file is uploaded, the Excel File data is available in the InputStream property of the FileUpload control.

Using ClosedXml library, the Excel file data can be easily read from the InputStream property and displayed on Web Page using GridView in ASP.Net using C# and VB.Net.
24 Jul 2018 24 Jul 2018 0 Comments  8901 Views
Here Mudassar Ahmed Khan has explained with an example, how to read Excel file directly from FileUpload control without Saving file in ASP.Net using C# and VB.Net.

When the Excel file is uploaded, the Excel File data is available in the InputStream property of the FileUpload control.

Using ClosedXml library, the Excel file data can be easily read from the InputStream property.
01 Jun 2018 01 Jun 2018 0 Comments  30278 Views
Here Mudassar Ahmed Khan has explained with an example, how to read and import Excel file directly from Stream without saving in Folder (Directory) on Server’s Disk in ASP.Net using C# and VB.Net.

When the Excel file is uploaded, the Excel File data is available in the InputStream property of the FileUpload control.

Using ClosedXml, the Excel file data can be easily read from the InputStream property.
01 Jun 2018 01 Jun 2018 1 Comments  57198 Views
Here Mudassar Ahmed Khan has explained with an example, how to read (import) Excel file without using OLEDB or installing Microsoft Office Excel or Interop Library in C# and VB.Net.

The Excel file will be read using ClosedXml and OpenXml DLLs which does not require OLEDB and does not require Microsoft Office Excel or Interop Library software to be installed.
01 Jun 2018 01 Jun 2018 1 Comments  27661 Views
Here Mudassar Ahmed Khan has explained with an example, how to read and import Excel file using FileUpload control without saving in Folder (Directory) on Server’s Disk in ASP.Net using C# and VB.Net.
01 Jun 2018 01 Jun 2018 0 Comments  44128 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  22811 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  23324 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  50175 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  43322 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.
18 Jul 2017 18 Jul 2017 7 Comments  69807 Views
Here Mudassar Ahmed Khan has explained with an example, how to export to Excel file 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.
10 Nov 2016 10 Nov 2016 0 Comments  17978 Views
Here Mudassar Ahmed Khan has explained with an example, how to export Grid (Html Table) data from database to Excel file in ASP.Net MVC Razor.
First 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 Microsoft Excel file using ClosedXML Excel Library which is a wrapper for OpenXml Excel library.
06 Jan 2016 06 Jan 2016 0 Comments  43017 Views
Here Mudassar Ahmed Khan has explained with an example, how to export GridView data to multiple Sheets (Worksheets) of same Excel file in ASP.Net using C# and VB.Net.
Records of each page of GridView with paging enabled will be exported to a different Excel sheets (worksheets) using ClosedXML and OpenXml Libraries.
19 Oct 2015 31 May 2018 4 Comments  165096 Views
Here Mudassar Ahmed Khan has explained with an example, how to read and import Excel file (Excel sheet) data to GridView using ClosedXml library in ASP.Net using C# and VB.Net.