Profile picture for user cfdutoit

Hi Guys,

Why is there no Column manipulation methods in ARIS script classes?

I create a fixed number of columns for a specific content type in the Excel template file, I then want to remove (delete) the columns that was not used for content.

When you look at the Sheet class in ARIS scripting, you will find methods for row manipulation, but litlle to nothing around column manipulation.

I use an Excel template using this command:

        var xlsTemplateData = Context.getFile("Template.xls", Constants.LOCATION_SCRIPT)

I can delete rows with:

sheet.removeRow ( XlsRow p_row )

but NO removeColumn command exist..

Any ideas?





by Francois Du Toit Author
Posted on Sun, 11/18/2012 - 22:17


After some reading I found that the Classes they use for Excel is the POI classes, and that these classes do not have any column based manipulation, so this seems to not to be a Software AG/ARIS oversight, but rather the available tools used. I did find some work arounds suggested, but they did not work in my testing.

I will continue looking for a solution and will share my findings here :)

Please let me know if you find a working solution in ARIS scripting, but for now, the users will have to delete the unwanted columns manually :(






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


There is still some space in this week's top 5 for you - this is your chance to become one of our top members of this week. Register now to start collecting points!
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