Hi,
I want to import data from an Excel file to ARIS.
Is that possible and if yes, could anybody be so kind and post a code example how to achieve that?
Thanks a lot.
4 Replies
Hi,
thank you for your replay.
I want to use the Excel-Data IN THE SCRIPT for further computing (I don't want to create models/objects), so I fear the processgenerator doesn't suit. Furthermore, I didn't find any processgenerator, that imports Excel files, only XML.
So I think I do need code, and I would really appreciate, if somebody could send me a short example.
Hi Florian,
in ARIS report you can use the ExcelReader.
Example:
var workbook = Context.getExcelReader(file.getData());
var isheets = workbook.getSheetCount();
for( var sheetc = 0; sheetc < isheets; sheetc++ ) {
var worksheet = workbook.getSheetAt(sheetc);
}
Jens
kalyan modium on
Hi,
I tried importing Excel files but could not do it successfully.