When creating a new script or looking in the properties of an existing script (ARIS 9.7) I see that the old and the new Word formats are supported (doc and docx) but that for Excel only the xls format is supported.
Is there a possibility to create a report in xlsx format from a script?
In the ARIS script help I see that there is a constants.arisoutputformattype which has an outputformat OutputXLSX but even when creating a new script in ARIS 9.7 I can only specify xls as output format via the properties dialog.
How can I let my script give the user the option of selecting xlsx output?
I'm using ARIS 7.2.4 and I also wanted to be able to generate XLSX files.
The only way I found to do it is to
- create the XLS output file (but name it with ".xlsx" format) using createOutputObject()
- use the writeReport() function to close it
- prepare all your content using the Apache POI Workbook API (normally already installed on your ARIS).
- then re-open the same file to write inside (get the file with getCurrentPath and open it with java.io)
I clearly don't know where and when does the transformation occurred, but it works perfectly fine and that's what matter.
I prefer using Apache POI API because I had problem with setCellFormula method