Loading

how to read from excel and write into database

how to read from excel and write into database

shreyas adikumar

6y750Learn iOS Programming

Hi i am trying to read the data from excel into the database in win from asp.net application can any one please suggest me it will be really helful

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pusting6y ago
Accepted answer
One of the simplest ways I used is this:
ExcelFile workbook = ExcelFile.Load("Path to your Excel file.");
ExcelWorksheet worksheet = workbook.Worksheets[0];

CreateDataTableOptions options = new CreateDataTableOptions();
DataTable dataTable = worksheet.CreateDataTable(options);

using (SqlBulkCopy bulkCopy = new SqlBulkCopy(yourDbConnection))
{
    bulkCopy.DestinationTableName = yourDbTableName;
    bulkCopy.WriteToServer(dataTable);
}
The code uses GemBox.Spreadsheet, you can find the example of exporting Excel as DataTable on:

https://www.gemboxsoftware.com/spreadsheet/examples/c-sharp-export-excel-to-datatable/502
0
Leon D6y ago
Hi,

You can install Free Spire.XLS via NuGet and refer to the below code to easily import data from Excel to DataTable.
Workbook workbook = new Workbook();
workbook.LoadFromFile(@”..\FandH.xlsx”);

Worksheet sheet = workbook.Worksheets[0];
DataTable dt = sheet.ExportDataTable();
Check this link for more information:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html
0
Amit Mohanty6y ago
Hey check the below link.

https://www.c-sharpcorner.com/blogs/saving-excel-file-data-to-sql-server-database

https://www.aspsnippets.com/Articles/Import-Excel-data-to-SQL-Server-Database-in-ASPNet-using-C-and-VBNet.aspx

https://www.c-sharpcorner.com/blogs/import-and-export-data-from-excel-to-database
0