Perspective Table excel report

Amir_Farmanbar · March 3, 2023, 6:27pm

I wonder is it possible to get an excel report from Perspective table info? someone just click on button and export all info to excel file?

bschroeder · March 3, 2023, 6:41pm

Slap a button on the view, grab the dataset from the table and run it through system.dataset.toExcel: system.dataset.toExcel - Ignition User Manual 8.1 - Ignition Documentation and system.perspective.download system.perspective.download - Ignition User Manual 8.1 - Ignition Documentation

Stripped example from a working application:

tableDS= self.parent.getChild("Table").props.data
excelBytes= system.dataset.toExcel(True,tableDS)
fileName = 'TableExport{}.xlsx'.format(system.date.format(system.date.now(),'yyyMMd_kms'))
system.perspective.download(fileName,excelBytes,'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')

Amir_Farmanbar · March 6, 2023, 2:29pm

bschroeder:

tableDS= self.parent.getChild("Table").props.data
excelBytes= system.dataset.toExcel(True,tableDS)
fileName = 'TableExport{}.xlsx'.format(system.date.format(system.date.now(),'yyyMMd_kms'))
system.perspective.download(fileName,excelBytes,'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')

Thank you. It works.