Category - Excel
Results 1 - 5 of 119
29 Jun 2021 29 Jun 2021 0 Comments  918 Views
Here Mudassar Ahmed Khan has explained with an example, how to download Excel file in ASP.Net Core MVC.

The data from the database is fetched using Entity Framework and then the data is downloaded as Excel file using ClosedXML Excel library in ASP.Net Core MVC.
29 Jun 2021 29 Jun 2021 0 Comments  767 Views
Here Mudassar Ahmed Khan has explained with an example, how to read (import) Excel file in ASP.Net Core MVC.

The uploaded Excel file data will be read using OLEDB library and the read data will be inserted into SQL Server database using SqlBulkCopy class in ASP.Net Core MVC.
29 Jun 2021 29 Jun 2021 0 Comments  709 Views
Here Mudassar Ahmed Khan has explained with an example, how to export DataSet or DataTable to Excel file in ASP.Net Core MVC.

The data from the database is fetched using ADO.Net into 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.
19 Dec 2020 19 Dec 2020 0 Comments  8783 Views
Here Mudassar Ahmed Khan has explained with an example, how to download Excel file using AJAX in jQuery.

The Excel file will be downloaded as BLOB using jQuery AJAX and XmlHttpRequest (XHR) request and then the file will be downloaded using the Response inside the Success event handler of jQuery AJAX function.
19 Dec 2020 19 Dec 2020 0 Comments  7302 Views
Here Mudassar Ahmed Khan has explained with an example, how to download Excel File on Button click using JavaScript.

The Excel file will be downloaded as BLOB using XmlHttpRequest AJAX call and then will be sent for download in the Browser using JavaScript.
Results 1 - 5 of 119