Export to Excel

Ignition
1

I have this script on a button but it doesn’t work.

table = event.source.parent.getComponent("Table")
filePath = system.dataset.exportExcel("data.xls", 1, table)
if filePath != None:
   system.net.openURL("file://"+filePath)

when I push the button this happen

The excel was created but when I tried to open it it says It can’t read.

2

MoisesZV

you only want the table data

table = event.source.parent.getComponent("Table") filePath = system.dataset.exportExcel("data.xls", 1, table.data) if filePath != None: system.net.openURL("file://"+filePath)

3

thanks now is working but still get this error “illegal character in authority at index 7” when I create the file.

4

Things changed (in Java, I think) with how openURL works. It’s now a lot less friendly. :confused:

Doug Keller had a working solution in this post.

5

[quote=“JordanCClark”]Things changed (in Java, I think) with how openURL works. It’s now a lot less friendly. :confused:

Doug Keller had a working solution in this post.[/quote]

Thanks Jordan! that solved my problem.