Excel Timestamp format

Ignition
1

We use this code to export data to a ‘Excel’ File:

table = event.source.parent.getComponent(‘Power Table’)
filePath = system.dataset.exportExcel(“datosPR.xls”, 1, table.data)

In one side we have problems opening the file. Several attemps must be made in order to open the file and see the data. ¿What could be the problem?

The other problem is that the tmstamp format is wrong (like a long integer). Cells format must be changed manually. ¿What could be the problem?

2

What version of Ignition are you using? If you’re on 8.0.7+, you can use the newer system.dataset.toExcel, which outputs a “real” Excel formatted spreadsheet in .xlsx format.

3 Likes