topic Re: Do we have any Widget to export data into Excel format in ESRI Web AppBuilder or ArcGIS Server JS API? in ArcGIS Web AppBuilder Questions

Do we have any Widget to export data into Excel format in ESRI Web AppBuilder or ArcGIS Server JS API?

Vara_PrasadM_S — Sat, 13 Apr 2019 19:35:47 GMT

Hi Team,

We have a requirement to export some tabular data into Excel format in our WebApp developed using ESRI Web AppBuilder. Do we have any widget for that? or any API in ArcGIS Server JS API?

What would be the best way to implement this.

Any suggestions would be very helpful to me.

Thanks & Regards,

Vara Prasad

Re: Do we have any Widget to export data into Excel format in ESRI Web AppBuilder or ArcGIS Server JS API?

Egge-Jan_Pollé — Sat, 13 Apr 2019 21:00:46 GMT

Hi Vara Prasad M S‌,

Yes, there is a setting in the Web AppBuilder for ArcGIS in the Attribute Table widget that you can set to Allow exporting to CSV (by default this option is turned off).

Once this option is set, the user can open the Attribute Table and go to Options > Export all to CSV to get all attribute data or apply a Filter first to get just a part of the data.

See screen captures below.

Hope this helps.

Regards,

Egge-Jan

Re: Do we have any Widget to export data into Excel format in ESRI Web AppBuilder or ArcGIS Server JS API?

Vara_PrasadM_S — Sun, 14 Apr 2019 11:50:03 GMT

Hi Egge-Jan,

Thanks a lot for your help.

We are looking for a custom format to be exported into Excel format. Not just as it is attribute table. Could you please let me know if we have any such options or any other best way to implement that.

Thanks & Regards,

Vara Prasad

Re: Do we have any Widget to export data into Excel format in ESRI Web AppBuilder or ArcGIS Server JS API?

NimaEkhtari — Wed, 20 Nov 2019 17:13:47 GMT

Hey Vara,

Did you find a way to create a custom report and export in xlsx format? I need to do the same thing for a few of my projects.

Re: Do we have any Widget to export data into Excel format in ESRI Web AppBuilder or ArcGIS Server JS API?

Vara_PrasadM_S — Mon, 16 Dec 2019 05:33:52 GMT

Hi Nima Ekhtari‌

I have done it through pure JS. We do not have any widgets.

Thanks & Regards,

Vara Prasad

Re: Do we have any Widget to export data into Excel format in ESRI Web AppBuilder or ArcGIS Server JS API?

EduardoC_ — Fri, 17 Apr 2020 00:40:29 GMT

How can I do such thing, How can I develop from scratch the full functionality? Did you develop it as a WebApplicationBuilder widget?

Re: Do we have any Widget to export data into Excel format in ESRI Web AppBuilder or ArcGIS Server JS API?

WillWoodroof — Wed, 23 Jun 2021 15:59:16 GMT

Hey Vara,

Would you mind sharing the code? This sounds exactly like the functionality I need to create.

Thanks,

Will

Re: Do we have any Widget to export data into Excel format in ESRI Web AppBuilder or ArcGIS Server JS API?

Anonymous User — Tue, 29 Mar 2022 00:17:25 GMT

Thank you, Egge-Jan - your answer was helpful and straight to the point.

Re: Do we have any Widget to export data into Excel format in ESRI Web AppBuilder or ArcGIS Server JS API?

diaconori — Tue, 30 Aug 2022 13:00:58 GMT

Where is the down vote button when you need it. What's the purpose of posting on his thread if you're not willing to show a working example or solution to the problem? We're a knowledge sharing site. Contribute or leave please.