Export Data table in Excel using Web API.

If you're allowed to use .NET Excel library, try this

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html

Please refer below links.

https://www.c-sharpcorner.com/UploadFile/2b481f/export-the-excel-file-in-Asp-Net-web-api/
https://www.aspsnippets.com/Articles/Export-DataTable-DataSet-to-Excel-file-in-ASPNet-MVC.aspx

Hi Divyesh,

Please refer this thread which does same you are looking for,

https://www.c-sharpcorner.com/UploadFile/2b481f/export-the-excel-file-in-Asp-Net-web-api/

follow the article

https://www.c-sharpcorner.com/article/read-excel-file-in-web-api-using-c-sharp/