Category - Excel
Results 1 - 5 of 62
Here Mudassar Ahmed Khan has explained with an example, how to export HTML string to Excel file in ASP.Net MVC Razor.

First the Grid (Html Table) will be populated from database using Entity Framework and then the HTML Table will be sent as HTML string to the Controller which ultimately will be exported to Excel file in ASP.Net MVC Razor.
Here Mudassar Ahmed Khan has explained with an example, how to export SQL data to Excel file with Column Headers (Column Names) in C# and VB.Net.

The records from the SQL Server database Table are fetched into a DataTable and then the DataTable will be exported to Excel file using the ClosedXml library in C# and VB.Net.
Here Mudassar Ahmed Khan has explained with an example, how to export DataTable data to Excel file in ASP.Net using C# and VB.Net.

First the DataTable will be populated with records from Database and then using the data from DataTable will be exported to Excel using ClosedXml library which is wrapper of OpenXml library.
Here Mudassar Ahmed Khan has explained with an example, how to use the SqlBulkCopy class in ASP.Net MVC Razor.

This article will illustrate 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.
15 Sep 2017 0 Comments  4797 Views
Excel  jQuery  HTML  Table
Here Mudassar Ahmed Khan has explained with an example, how to convert (export) HTML Table to Excel file using jQuery.

This article will explain how to convert (explain) HTML Table to Excel file with the help of the jQuery table2excel plugin.
Results 1 - 5 of 62