Read Data From Excel and Export IT To Database

[hamzasukkar]

Hi...
Please how I Can Read a data from excel file and upload it to my database in Asp.net MVC Core ....
Thank you...

[Sofia.Yang]

Hello,

Thanks for your post.
Our Spire.XLS supports exporting data from Excel to a DataTable in Asp.net MVC Core application. Please use our latest package (Spire.XLS Pack(Hotfix) Version:10.8.3) from the following links and refer to the sample code to have a test. If there is any question, welcome to write us.
Website link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS/

Code: Select all

//Load xlsx file
Workbook workbook = new Workbook();
workbook.LoadFromFile("test.xlsx");
//Get the first worksheet
Worksheet sheet = workbook.Worksheets[0];
//Specify the cell range
CellRange range = sheet.Range[1, 1, 3, 2];
//exporte data to a DataTable
DataTable dt = sheet.ExportDataTable(range, true, true);

Sincerely,
Sofia
E-iceblue support team

[hamzasukkar]

Thank you...
It's work

[Sofia.Yang]

Hello,

Thanks for your feedback.
If you encounter any issue related to our products in the future, just feel free to contact us.
Wish you all the best!

Sincerely,
Sofia
E-iceblue support team