How to Read excel file data and save data to sql server in A

Question

How to Read excel file data and save data to sql server in Asp.net Web Api2. I am working on a WEB Api project. I want to do Import/Export functionality . Can anyone give some solution for this ASAP.

Ravi Patel · Answer

Hi go through following reference http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql-server-database-using/ https://bytescout.com/products/developer/spreadsheetsdk/read-write-excel.html first one is very good demo If you find my post as useful then accept my reply as answer. :)

Kiran K · Answer

String sOutput = fNumber1.ToString(n3); and String sOutput = fNumber2.ToString(n1); whats the difference btween n3 and n1 at the ends.

Kiran K · Answer

hey help me

Mozart He · Answer

Hi Sakshi For free version and commercial version with support you could try Spire.XLS. Please refer to the tutorial: http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html For open source solution you could try NPOI. Please see the tutorial below: http://npoi.codeplex.com/SourceControl/latest#NPOI.Examples/ImportXlsToDataTable/Form1.cs They both don't need Excel installed on the server side.

Nilesh Jadav · Answer

Have you checked these Reference : 1) http://www.aspsnippets.com/Articles/How-to-Import-Excel-Sheet-data-into-SQL-Server-using-ASPNet.aspx 2) http://dotnetawesome.blogspot.com/2013/11/how-to-import-export-database-data-from_18.html 3) http://www.scriptscoop.net/t/3d0a5d3e535a/c-how-to-import-and-export-an-excel-file-using-asp-net-web-api-2-2.html 4) http://www.tejaprakash.com/2013/07/importexport-ms-excel-file-data-to.html Hope that helps !!