how to read from excel and write into database

Question

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

Pusting · 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

Amit Mohanty · Answer

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

Leon D · Answer

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

how to read from excel and write into database

Answers (3)