How to merge cells

Last activity on October 1, 2023 - 11:21 192 Views 2 Replies Reports & Macros

Helmy Jeddi on February 17, 2021

Hello !

I'm working on a report to ouptut an XLS file. I would like to merge the cells in the first row to do as in the following picture :

I did some research and I found this function : addRegion ( int p_nFromColumn, int p_nToColumn, int p_nFromRow, int p_nToRow )

However, ARIS doesn't recognize this function and I get this error when I try to execute my script :
TypeError: Cannot find function addRegion in object...

Here is my code :

var oOutput = Context.createOutputObject()
var selectedModel = ArisData.getSelectedModels()[0].ObjDefList();
createSection2(oOutput, selectedModel,selectedModel)

function createSection2(p_output, p_Models,array)
{
//Columns creation (p_output.BeginTable...)
//Rows & cells creation
p_output.addRegion(1, 5, 1, 1)

}

If I remove the function AddRegion, the script works and I get the same sheet as shown in the picture, but with multiple cells in the first row.

Can anyone help me please ?

Regards,
Helmy

Bookmark

Notify Moderator

Best Reply

Nikita Martyanov on February 17, 2021

Hello Helmy, try to use this code. addRegion is the method of the sheet object, not the output object. And sheet belongs to workbook.

var oOutput = Context.createExcelWorkbook(Context.getSelectedFile());
var sht = oOutput.createSheet("SheetName");
sht.addRegion(1,5,1,1);
oOutput.write();

BR, Nikita

or register to reply.

Show in context Notify Moderator

Reset Password