Base solution for your next web application
Open Closed

Export To Excel #2593


User avatar
0
maharatha created

Hi -

I have a grid which gets it's data from a Web API let's .../api/services/app/GetVendors. Now it returns let's say 50 records when I send a request with page size and it renders to the grid. All works fine.

Now I want to add a button called "Export To Excel" which will consume the same API and return all the vendors which I can do it by sending page size as -1. This is fine as well.

But what I need is to able to specify the formatted output for the API which could be json or XM whil accessing the API.

My plan is use the below link which returns an excel from teh WebAPI by formatting the output .

<a class="postlink" href="http://webapicontrib.github.io/WebApiContrib.Formatting.Xlsx/">http://webapicontrib.github.io/WebApiCo ... ting.Xlsx/</a>


5 Answer(s)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    Thanks for sharing this idea. We will try this soon and let you know if this is possible for now or not with the current version of ABP.

  • User Avatar
    0
    maharatha created

    Awesome. Looking forward to it !!!

  • User Avatar
    0
    maharatha created

    Any updates ?

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    We didn't have time to try this, I will try to do it tomorrow.

    Thanks.

  • User Avatar
    0
    maharatha created

    Did you get a chance to try ?