MP

Hi Aris community,

I need create an excel workbook starting from a template and to modify only few data:

var sfile = Context.getFile(filename, Constants.LOCATION_SCRIPT);
if (sfile != null && sfile != undefined) {

    var p_output = Context.createExcelWorkbook ( Context.getSelectedFile() , sfile);

}

I need also to insert new rows in some position, shifting the next ones, but the method:

p_output.sheets[0].createRow (pos)

doesn't create a new row, it only returns me the existing row at position pos.

Is there any way to insert a new row (whithout using explicity org.apache.poi)?

Maggiù

 

by Francois Du Toit
Posted on Tue, 08/15/2017 - 21:57

Hi,

As far as I know inserting rows is not possible, removing rows are. I added example 10 rows on my template, then remove the ones not in use. Not ideal, but does provide a work-around...

Rgs,

Francois

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

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