system.report.executeReport new XLS filetype error (Bug?)

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 :bug:?

:frowning: 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