bfuson
December 19, 2017, 7:40pm
1
I’m attempting to execute and save a report as an excel file (.xls) using the system.report.executeReport() function.
The line:
xls = system.report.executeReport('Downtime Report', fileType="xls")
throws error:
com.inductiveautomation.ignition.client.gateway_interface.GatewayException: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Unknown file format requested
According to the docs, xls support was added in 7.9.5, the version I am running.
Could this be a ?
bfuson:
Could this be a ?
Sure is - the client can save reports in XLS format directly from the report viewer, and scheduled report actions can save to XLS format - but the scripting functions got overlooked so they throw that error.
I've filed an internal ticket to get this fixed.
3 Likes
Hello… I am also facing the same error when exporting to XLS format.
I am running Version: 7.9.8 (b2018053113)
com.inductiveautomation.ignition.client.gateway_interface.GatewayException: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Unknown file format requested
caused by GatewayException: Unknown file format requested
caused by IllegalArgumentException: Unknown file format requested