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

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

2

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

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
4

Did this bug ever get fixed for any version of 7.9.x? Using 7.9.14 and still not working. - Thanks

5

AFAICT this wasn't fixed until Ignition 8.0.7.

1 Like
6

Thanks