When you click the OK button, another window will appear on your screen for template selection where you have to select WEB API and click on the OK button.
To create web API, open the visual studio 2019 > file > new > project > Select Web Application. Now, we have to create a WEB API to read the records of students from the excel file and insert them into the student table using an entity framework.
#Jxl api read xlsx file how to
In this tutorial, we are using Visual Studio 2019 and explaining how to create a table in an SQL server database, how to create an ADO.NET entity data model (EDM) as well as how to create a WEB API controller and way to write an action method in the WEB API controller and way to test the created WEB API using postman.Ĭreate Table Student CREATE TABLE . So, today in this article I will explain how to read the data from excel files in web API as well as a way to insert that data into the database table using the entity framework. I got many emails from my readers to write an article on upload and read excel files in WEB API using c#. While you working with any applications either that is a windows application or a web application, this is a common requirement, to read an excel file and insert the data into the database. I will also explain how to insert the data from an excel file to the SQL server database table using the entity framework in web API.
In this article, I am going to explain how to upload and read excel file in excel in web API using c#.