Merge Cells in EXCEL Reports

Last activity on October 1, 2023 - 11:21 27.5k Views 7 Replies Reports & Macros

JeyaKarthik N R on December 10, 2014

Hi,

I want to publish a excel report with merged cells. I am unable to merge the cells.

output = Context.createExcelWorkbook("Book");

sheet = output.createSheet("Sheet1");  
row1= sheet .createRow(0);

row2= sheet.createRow(1);
//I want to merge first coumn and second column of second row 
//So I tried this
sheet .addRegion(0,1,1,1);
//But it always throws me an error!!

When I use above code I am getting Error Index:1 Size=0

Can anyone guide me on this please?

Tags: #arisreportscripting

Bookmark

Notify Moderator

7 Replies

Eva Klein on December 10, 2014 - 10:33

I hope this will help you. If you have further questions please feel free to ask me.

var workbook = Context.createExcelWorkbook(Context.getSelectedFile());
var sheet = workbook.createSheet("Sheet1");   
sheet.addRegion(0,1,1,1); 
workbook.write();

Regards

Eva

or register to reply.

Notify Moderator

JeyaKarthik N R Author on December 10, 2014 - 10:49 as Reply to Eva Klein

Still getting same error index:1 size:0

or register to reply.

Notify Moderator

JeyaKarthik N R Author on December 10, 2014 - 11:20 as Reply to JeyaKarthik N R

Hi Eva,

Thanks a lot.!

Your code works!!. I got it after replacing filename in createExcelWorkbook with Context.getSelectedFile

But I want to know what's difference between

var workbook = Context.createExcelWorkbook(Context.getSelectedFile());

And

var workbook = Context.createExcelWorkbook("FileName");

or register to reply.

Notify Moderator

Eva Klein on December 10, 2014 - 15:04

You're welcome.

With this version, the name for the report output is hard-coded and every output has this name ("FileName.xls").

var workbook = Context.createExcelWorkbook("FileName.xls");

With the following version, the report output is assigned the name that you had defined when you started the report and set the output settings ("Save output as").

var workbook = Context.createExcelWorkbook(Context.getSelectedFile());

or register to reply.

Notify Moderator

JeyaKarthik N R Author on December 11, 2014 - 07:50 as Reply to Eva Klein

Thanks Eva!!

Now it works perfect!.

or register to reply.

Notify Moderator

Sch J on January 14, 2015 - 10:29

Hi,

is there any way to do this, when using createOutputObject for creation of the object.

Like: outfile = Context.createOutputObject(Constants.OUTEXCEL, Context.getSelectedFile());

Thanks Sica

or register to reply.

Notify Moderator

Rahil Razac on August 13, 2015 - 18:55

Hello, I'm having a similar problem. But instead of creating a new excel i'm creating it from a template. the error gives me the following info:

index:11 size: 10

my code is:

    var xlsTemplateData = Context.getFile("Template.xlsx", Constants.LOCATION_SCRIPT)
    return Context.createExcelWorkbook(Context.getSelectedFile(), xlsTemplateData);

Thank you

or register to reply.

Notify Moderator

There are currently no upcoming events.