Import Excel Data

Hi,

I tried importing Excel files but could not do it successfully.

Hi,

there is no code needed. Use processgenerator.

Thanks

Abhijit Das

abhijit.das@cba.com.au

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