CD
Hi,
Can someone please explain in detail how to use the "use-new-output" and also how to use the new office formats in scripts. I have notice the output formats can be set - OutputXLSX, OutputDOCX - but how can we use this in the scripts, specially as the standard output even for the standard aris scripts available.
The BeginTable for example is part of the StandarAPIOutput how can I use this when using the ExtendedOutputObject.
In some other posts the TOC is missing when using the "use-new-output", sureley something extra needs to be done in order the have a TOC with the new output?
Ciska
|
|
Hi Jens,
Thank you but I know this command, the problem is when using this command or even when changing it in the config file to true, there is no TOC and commands like begintable does not work. I want to know what else needs to be done and also how can I utilize OutputXLSX and OutputDOCX.
Just for interest sake, I have added this command to the standard script Create Process Manual and it actually breaks at a begintable statement.....
Ciska
Hi,
I suppose output to xlsx in ARIS is not working, although claimed to be. I have tried everything possible acording to my knowledge as no working solution is available or made available.
By changing the setting in the config file (<report use-new-output="true" />) will enable the new office formats but only for docx, which is available as selection when creating reports, xlsx is not.
Changing the output format in the script by using Context.setSelectedFormat(Constants.OutputXLSX) - not working. Used the workbookobject by writing directly to excel (Context.createExcelWorkbook) - not working as well. Using a pre-defined xlsx template for each script in order to output to xlsx, haven't tried that, but is that really the way to go in order to get an output to xlsx for each script? I don't think so.
Surely if claimed that ARIS can ouput to xlsx why is it so difficult to do so? Is there a missing jar file, or wrong version of a jar file installed in the ARIS directory?
Ciska
Hi Brooke,
No, nothing at all, and also no response since my last post. I also experience problems when using the new word formats (docx) so I've reverted back by setting the (<report use-new-output="false" />).
All of our clients are using either Office 2007 or Office 2010, and by using the old office formats are causing issues (like colours for example).
It would be nice if we could get some answers regarding this - for both xlsx and docx! Not sure if the latest version of Aris 7.2 addresses these issues, maybe Aris 9.....
Ciska
I've got this to work.
for docx, "Context.setSelectedFormat" does not work, but createOutputObject does. So I use this.
Context.setProperty("use-new-output", true);
oldname = Context.getSelectedFile()
newname = oldname + "x"
var oOutput = Context.createOutputObject( Constants.OutputDOCX, newname)
I've also tried this with Output XLSX format. It works perfectly.
However, this means that the stock code needs to be rewritten. For example, the global header and footer text we so often take from WYSIWYG reports becomes very ugly and needs to be rewritten.
Hi Galvin,
Had a quick test, a xlsx output is generated the only thing, the colours are missing. For example the heading columns background is yellow, it turns out to be black when outputting to xlsx. This is for all formatting, text, background and so forth.
Unless I'm missing something?
Ciska
Hi Ciska,
You're right, I tested it on docx successfully. It doesn't seem to work for excel. the table is set to a background of black, although the rest of the sheet is set to no background)
The only background "colour" that works is "Constants.C_TRANSPARENT"
Also tried
- outexcel (doesn't work at all)
- outxlsm (doesn't work at all)
