I have created two reports using Aris 7.1 One is printing certain attributes of models. Another report is taking data from the newly created report and writing in a template excel that will create a heat map based on macros in the template excel. Now i want just one report that will serve both the purpose. When i try to create this thing i am stuck at a point how data will be read from excel even when it has not been created. We can use WriteReport function only once in the script. Any leads will be highly appreciated. 

Thanks in advance.

by Robert Goldenbaum
Badge for 'Question Solver' achievement
Posted on Thu, 01/14/2016 - 08:41


ahm, so you have report A, that writes data A into excel sheet A and then have a report B that reads data A from the written excel sheet A to generate data B ?

Why don't you just use data A directly to generate data B ?

You could also think about an excel sheet with multiple tabs but anyway, you have the data (when you want to write it to A) so why don't you just use this ?

BR Robert


Featured achievement

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
  • Profile picture for user frankweise
  • Profile picture for user Henrik Buckler
  • Profile picture for user UffeK
  • SS
  • MZ
  • PacMan


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