YD

Hello Community,

I am creating an xlsx file with the standard output file function,  Context.createOutputObject().

Is there any way to create a filter for each column in this excel table?

Thanks in advance!

 

by Robert Goldenbaum
Badge for 'Question Solver' achievement
Posted on Thu, 05/16/2019 - 14:07

Hi,

well, you could use a template file for creating the output file...

                    _strConfigFile = sNameTemplate;

                    _abTemplateFile = Context.getFile(_strConfigFile, Constants.LOCATION_SCRIPT);

                    _oWorkbook = Context.createExcelWorkbook(_sFileName, _abTemplateFile);    

 

BR Robert

0
by Ye Ding Author
Posted on Fri, 06/07/2019 - 13:21

In reply to by rgoldenbaum

Hello Robert,

thanks for your reply. However, with the "CreateExcelWorkbook" I can only create a xls file rather a xlsx file.

Do you know any similar method but the outcome is a xlsx file? Thanks.

0
by Robert Goldenbaum
Badge for 'Question Solver' achievement
Posted on Fri, 06/07/2019 - 13:53

In reply to by WorkingOnAris

                    _strConfigFile = Context.getScriptInfo(Constants.SCRIPT_NAME) + ".xlsx";

                    _abTemplateFile = Context.getFile(_strConfigFile, Constants.LOCATION_SCRIPT);

                    _oWorkbook = Context.createExcelWorkbook(_sFileName, _abTemplateFile);    

Works with xlsx as target as well... You just have to set the output format for the output file to xlsx

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • CR
  • BH
  • Profile picture for user Ivan.Ivanov.softwareag.com
  • Profile picture for user mscheid
  • MS
  • 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