FF

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.

by kalyan modium
Posted on Thu, 05/03/2012 - 15:28

Hi,

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

0
by Abhijit Das
Posted on Fri, 05/04/2012 - 04:00

Hi,

there is no code needed. Use processgenerator.

Thanks

Abhijit Das

abhijit.das@cba.com.au

0
by Florian Fuchs Author
Posted on Fri, 05/04/2012 - 10:26

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.

0
by Jens Heylmann
Posted on Fri, 05/04/2012 - 13:27

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

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • SS
  • MZ
  • Profile picture for user kbiront
  • Profile picture for user Tony Iliev
  • Profile picture for user amandeep.7.singh
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock