Scripting the Save As Excel method of the Report Viewer Component

Ignition
1

I see there is a right click menu option to “Save as XLS”, but I can’t find a way to access this functionality via a script the way the “Save as PDF” can be done using the “saveAsPDF” method. Is this not a built in function of the Report Viewer? Is there a way to glean what the right click menu option does in order to reproduce it?

Thanks,
Mike

2

Execute and distribute is what you want.

https://docs.inductiveautomation.com/display/DOC79/system.report.executeAndDistribute

1 Like
3

Or even, creatively, componentReference.saveAsXls(filename) - since that’s all that the popup menu is doing anyways.

1 Like
4

Thanks for the helpful input! :smiley: