hello, If I have a Table in on a View, Could I export all data to an EXCEL file? Could I use system.dataset.exportExcel? thank you all

Not 100% sure this is the reason, but if you are on a version 8.0.7 or higher, the toExcel() function will export the data as an “xlsx” instead of the older “xls” file type. It may go away if you set the file type to “xlsx”.

100% what osolorzano said. We had this issue and as soon as we added .xlsx it went away.

Any chance you would be willing to share your script? I changed to .xlsx and now excel just tells me the file format is not valid. I feel like I must be missing something basic here. This is my code data = self.parent.parent.getChild("Table").props.data headers = data[0].keys() system.perspectiv…

dataSetToExcel is the ‘legacy’, deprecated implementation. Use system.dataset.toExcel - it should be a simple swap.

that seems to have fixed my problem. I still have to manually add the “.xlsx” to the end of the file name in the save dialog box. Is there anyway to make that be automatic?

No; it’s up to your browser. The most you can provide to a browser is a suggested filename; whether the browser will use that (or parse it for an extension, etc) is out of our hands: https://developer.mozilla.org/en-US/docs/Web/API/HTMLAnchorElement/download

That makes sense. Just for the sake of putting this out there, Google Chrome uses the suggested file name, as does the latest version of Firefox. It was actually perspective workstation that was ignoring it. I’m not sure if that is something within IA’s power to change.

[image] jd1: It was actually perspective workstation that was ignoring it. I’m not sure if that is something within IA’s power to change. Huh, good to know - I let the relevant experts know about it. There might be something we can do to fix that.

This works too. data = self.getSibling(Table).props.data data = system.dataset.toExcel(True, [data]) system.perspective.download(‘filename.xlsx’,data)

Inductive Automation Forum

[Feature-13610]Export to Excel in Perspective Ignition 8

Ignition Early Access