Category - Excel
Results 1 - 20 of 120
02 Feb 2022 02 Feb 2022 0 Comments  7234 Views
ASP.Net  Excel  AJAX  jQuery  MVC  Word  PDF
Here Mudassar Khan has explained with an example, how to download File using jQuery AJAX in ASP.Net MVC Razor.

This article will illustrate how to download File from Folder (Directory) using jQuery AJAX in ASP.Net MVC Razor.
29 Jun 2021 29 Jun 2021 0 Comments  10835 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  13795 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  11505 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  26161 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  23141 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.
18 Dec 2020 18 Dec 2020 1 Comments  81938 Views
Excel  AJAX  jQuery  Word  PDF
Here Mudassar Ahmed Khan has explained with an example, how to download file in AJAX Response (Success) using jQuery.

The 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.
18 Dec 2020 18 Dec 2020 1 Comments  23162 Views
Excel  AJAX  jQuery  Word  PDF
Here Mudassar Ahmed Khan has explained with an example, how to download file as BLOB using AJAX and jQuery.

The PDF file will be downloaded as BLOB using jQuery AJAX and XmlHttpRequest (XHR) request and then will be sent for download in the Browser using jQuery.
18 Dec 2020 18 Dec 2020 0 Comments  16826 Views
Here Mudassar Ahmed Khan has explained with an example, how to download files from Folder (Directory) on Server's Disk in View in ASP.Net Core Razor Pages.
18 Dec 2020 18 Dec 2020 0 Comments  9050 Views
Here Mudassar Ahmed Khan has explained with an example, how to display List of files from Folder (Directory) on Server's Disk in View in ASP.Net Core Razor Pages.

The Files can also be downloaded from Folder (Directory) in ASP.Net Core Razor Pages.
15 Dec 2020 15 Dec 2020 0 Comments  12451 Views
Here Mudassar Ahmed Khan has explained with an example, how to export to Excel file in ASP.Net Core Razor Pages.

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.
12 Dec 2020 15 Dec 2020 0 Comments  21496 Views
Here Mudassar Ahmed Khan has explained with an example, how to export to Excel file in ASP.Net Core MVC.

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.
09 Dec 2020 09 Dec 2020 0 Comments  17910 Views
Here Mudassar Ahmed Khan has explained with an example, how to return an Excel File from Controller in ASP.Net MVC Razor using C#.

The Excel File will be generated from database using Entity Framework and then it will be returned from Action method of Controller with FileResult return type in ASP.Net MVC Razor.
09 Dec 2020 09 Dec 2020 0 Comments  25661 Views
ASP.Net  Excel  MVC  Word  PDF  Core
Here Mudassar Ahmed Khan has explained with an example, how to download files from Folder (Directory) on Server's Disk in View in ASP.Net Core MVC.
09 Dec 2020 09 Dec 2020 1 Comments  26141 Views
Here Mudassar Ahmed Khan has explained with an example, how to download File using jQuery AJAX in ASP.Net with C# and VB.Net.

This article will illustrate how to download a file using jQuery AJAX with the help of WebMethod in ASP.Net.
09 Dec 2020 09 Dec 2020 1 Comments  17579 Views
ASP.Net  Excel  AJAX  jQuery  Word  PDF  Web Method
Here Mudassar Ahmed Khan has explained with an example, how to download File from Web Method via AJAX call in ASP.Net using C# and VB.Net.

The AJAX call will be done using jQuery AJAX function and the file will be converted to Base64 string and downloaded from Web Method in ASP.Net.
18 Jun 2020 18 Jun 2020 0 Comments  33931 Views
Here Mudassar Ahmed Khan has explained with an example, how to import (insert) Excel file data into Database using SqlBulkCopy 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.

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 using the SqlBulkCopy class.
17 Jun 2020 17 Jun 2020 1 Comments  129269 Views
ASP.Net  Excel  Tips  OLEDB
Here Mudassar Ahmed Khan has explained how to download the Microsoft.ACE.OLEDB.12.0 provider for 32bit and 64bit.

In order to download the Microsoft.ACE.OLEDB.12.0 provider for 32bit and 64bit, you will need to download the Microsoft Access Database Engine 2010 Redistributable file.
08 May 2020 08 May 2020 0 Comments  15993 Views
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.
06 Sep 2019 06 Sep 2019 0 Comments  36224 Views
Here Mudassar Ahmed Khan has explained with an example, how to download (save) VARBINARY data as File from SQL Server database table in ASP.Net using C# and VB.Net.

Files such as Images, PDF, Word or Excel Documents, Audio and Video files will be saved as VARBINARY data in SQL Server database table and later the VARBINARY data will be converted back to the file and downloaded in ASP.Net using C# and VB.Net.
Results 1 - 20 of 120