Hi,
Is there a way to save ION output files in Excel (not just CSV) format?
Regards,
Kirill
Can you describe the flow? What is the input and where do you want to send the excel file?
One idea would be to convert the csv through a python script to an excel file and then you should be able to send it as an excel file to your endpoint.
what I've tried before is created a zip file in CSI10 Custom assembly and send the binary and extension to ION then ION write it to an FTP folder.
If DLL dealing with excel that you need is available in CSI10 Cloud Custom assembly then it might be possible and just use ION to carry files.
Hi Marcus,
I generate XML file in M3 MEC, send it to ION.
Now I would like to convert XML file to Excel file and either save it in a network folder or email it.
I found a python code to create Excel file
NJSONtoXLSXBinary.py · main · Billy Willoughby / Infor Python · GitLab
But it requires Libraries in ION:
et_xmlfile
openpyxl
Yes that will work - you can import the libraries to ION - see for example the documentation here - docs.infor.com/.../default.html
