Data Export an Edited Table

[mabraham]

I'd like to export some of the data in a grid. I have attached the all data from my service to the grid, configured the grid columns so that they are user friendly (Ex. OwnerEmail to Owner Email) and removed the grid columns, that I do not want to see and download. I bound the Data Export widget to the edited table, but the mashup will not download the edited table. How can I get the export widget to download the edited table?

When i bind the data from the service directly, I can export all the data. However the column titles are not user friendly and there are columns I do not want to download.

Thank you

[dupatel]

Mivil Abraham​: Have you tried using Advanced Data Grid extension available on marketplace along with Export Data widget to see if that helps you with your use case.

[CarlesColl · Accepted solution]

Hi Durgesh, I don't think it would help, as Data Export widget gets the raw data from the service result not from the Grid. If you want to customize the export format, you will have to build a service that formats the data as you want on the export, and bind this service to the Export widget instead of the service that fills the grid.

[dupatel]

Yes, Carles agree with you. Just suggested widgets which might be of help however writing service as suggested should be the way.

-Durgesh

[mabraham]

Thank you Charles and Durgesh. This is what I figured too.