OpenXml Articles

Category - OpenXml

08 May 2020 Mudassar Khan 0 Comments 3878 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.

01 Jun 2018 Mudassar Khan 0 Comments 20044 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 0 Comments 44979 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 19556 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 33539 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.