How to create a button that converts custom widgets to excel

[Salvatore B]

Hello,
I created a page in Service Portal with custom widget which retrieve aggregate information in different tables. This widgets can be pie charts or tables.

I need to create a button that replicates these widgets in an excel sheet.

Has anyone ever developed this button?
Thanks

[Iraj Shaikh]

Hi @Salvatore B 

Please refer the community post below
https://www.servicenow.com/community/developer-forum/custom-widget-on-service-portal-to-export-table...

Please mark this response as correct or helpful if it assisted you with your question.

[Salvatore B]

Hi @Iraj Shaikh ,
thanks for the reply but the proposed solution exports data from a specific table in Servicenow.
Instead, I should be able to export the data I display to a custom widget because it contains values from multiple tables that I retrieved via server script.

[ashishdevsingh]

HI @Salvatore B ,

I have never done this within serviceNow but you can integrate the MS azure data lake with ServiceNow and store your information. then you can create reports the way you want to. By doing this you can use Power Bi features which is more advance than serviceNow reporting.