Hi everyone,

I want to create an excel using the report with the functions Context.createOutputObject() and WriteReport().

Actually it works now in report. But If I use Macro to execute the report, the excel file won't be generated.

There is no error message and the Macro is certainly correct. I have no idea why I can't get the excel file.

Also I used the same functions in other report but in that new report it also doesn't work. No error message but no output file.

Could anyone give some suggestions? What problems could it have when I want create an excel file? Thanks in advance.


by XT G Author
Posted on Tue, 10/15/2019 - 16:27

Ok I find the problem.

In report, I have to add


And in macro there should be setProperty.


by Kay Fischbach
Posted on Wed, 10/16/2019 - 10:08

In reply to by xiaotian.guo

I don't exactly know what your Macro looks like, but if you would use the correct methods in the Macro there shouldn't be a need to explicitly call .setSelectedFormat(...) and .setSelectedFile(...).

Does your Macro use a function called createExecInfo(...) to prepare the report execution? There are different versions of this method available, some with more parameters and other with less parameters. Use one of those functions that specifies the output format, output path and output file name, and there shouldn't be any difference between manually starting the report and letting the macro start the report.


Featured achievement

You blog more than you breathe, and your articles stand out: Create 20 more articles, receive very good feedback and stimulate conversations
Recent Unlocks


Weekly | All-time
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