ClosedXml Articles

Category - ClosedXml

08 May 2020 Mudassar Khan 0 Comments 27187 Views

ASP.Net Excel GridView OpenXml ClosedXml

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 Mudassar Khan 0 Comments 10679 Views

ASP.Net Excel GridView DataTable FileUpload ClosedXml

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 Mudassar Khan 0 Comments 39796 Views

ASP.Net Excel GridView Tips FileUpload OpenXml ClosedXml

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 Mudassar Khan 1 Comments 65655 Views

Excel DataGridView Windows Forms DataTable OpenXml ClosedXml

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 Mudassar Khan 1 Comments 35394 Views

ASP.Net Excel GridView FileUpload OpenXml ClosedXml

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 Mudassar Khan 0 Comments 49588 Views

Excel DataGridView Windows Forms OpenXml ClosedXml

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 Mudassar Khan 0 Comments 28161 Views

Excel DataGridView Windows Forms DataTable OpenXml ClosedXml

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 Mudassar Khan 0 Comments 28397 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.

18 Jul 2017 Mudassar Khan 2 Comments 64814 Views

ASP.Net Excel ClosedXml MVC

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 Mudassar Khan 0 Comments 49857 Views

ASP.Net Excel DataTable ClosedXml MVC

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 Mudassar Khan 8 Comments 82811 Views

ASP.Net Excel ClosedXml MVC

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 Mudassar Khan 0 Comments 20536 Views

ASP.Net Excel ClosedXml MVC

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 Mudassar Khan 0 Comments 47336 Views

ASP.Net Excel GridView ClosedXml

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 Mudassar Khan 4 Comments 187207 Views

ASP.Net Excel GridView ClosedXml

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.