cfdutoit's picture

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?

Thx,

Francois

 

 

Tags: excel Report script