Calling WEB API to download excel file

Sujit Sahoo

Here i can store my value from database as a IEnumerable result type ....

how can i convert this file to excel so that direct call web api the excel file will be downlaoded.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
You can try this method
// GET api/values/
    public HttpResponseMessage Get()
    {

        //DataTable Dt= GetData();  Getdata from database in thr form d
        //Generate  html table sturcture
        string str = "
colume1
abc
";
        HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK);
        result.Content = new StringContent(str);
        result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.ms-excel");
        result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment"); //attachment will force download
        result.Content.Headers.ContentDisposition.FileName = "data.xlsx";
        return result;
    }
Barath Kumar M5y ago
Please check the below link

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