Category - Excel
Results 1 - 5 of 57
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.
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.
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.
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.
Here Mudassar Ahmed Khan has explained with an example, how to import (insert) data from Excel file into SQL Server database table using SqlBulkCopy in ASP.Net MVC Razor.

The uploaded Excel file data will be read using OLEDB library and the read data will be inserted into SQL Server database table using SqlBulkCopy.

SqlBulkCopy class as the name suggests does bulk insert from one source to another and hence all rows from the Excel sheet can be easily read and inserted into SQL Server database table using the SqlBulkCopy class.
Results 1 - 5 of 57