[ SOLVED ] Export csv error CREATED PROCESS ERROR=2

Ignition
,
1

Hello,

I have this code in a button:

table =event.source.parent.getComponent("tblPedidoscabecera")
filePath=system.dataset.exportExcel("Estadisticas_Pedidos_Rutas_T. Pedidos_ Confirm. SAP.xlsx",1,table.data)
if filePath != None:
	system.net.openURL("file:///"+filePath.replace('\\','/'))'''

And when I clic on it, I got this error, this code should export a information from a table that is named as tblPedidoscabecera and then should open it but says this:

image
image1167×259 22.7 KB

2

What is the output or identical pseudo output for this:

table =event.source.parent.getComponent("tblPedidoscabecera")
filePath=system.dataset.exportExcel("Estadisticas_Pedidos_Rutas_T. Pedidos_ Confirm. SAP.xlsx",1,table.data)
print filePath
1 Like
3

Your java install is asking your OS how to launch that file type, and your OS is saying to use command.com, the ancient predecessor to cmd.exe. You have an OS configuration error. Consider using java's ProcessBuilder to launch Excel's executable directly.

1 Like
4

I found the error, I just need to remove the ".xlsx" because I could not open the file after saving.
By the way, I did not have the software to open the file.

table =event.source.parent.getComponent("tblPedidoscabecera")
filePath=system.dataset.exportExcel("Estadisticas_Pedidos_Rutas_T. Pedidos_ Confirm. SAP",1,table.data)
if filePath != None:
	system.net.openURL("file:///"+filePath.replace('\\','/'))'''
1 Like