Hello All,
I’m creating an excel output using an ARIS report script with Context.createExcelWorkbook() and can successfully write rows, styles and formatting, but I haven’t been able to find any built‑in ARIS function that lets me create an Excel drop‑down list (data validation) in a cell. None of the standard script examples/ARIS help website seem to show this either. Is it actually possible to add a drop‑down list to a each cell from within ARIS report scripting? Any and all help is appreciated.
Florian Gerdes on
Hello.
One solution could be to not create an excel file from scratch.
You could create an excel file with this dropdown as template and just fill this template via the report.
The needed functionalities would be:
var template = Context.getFile("template.xlsx", Constants.LOCATION_COMMON_FILES);var wb = Context.createExcelWorkbook("filename.xlsx", template);Kind regards,
Florian