Merge Cells in EXCEL Reports

Posted by JeyaKarthik N R

Posted on Wed, 12/10/2014 - 08:20 in Reports & Macros

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?

ARIS Report Scripting

27.5k

by Eva Klein

Posted on Wed, 12/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

by JeyaKarthik N R Author

Posted on Wed, 12/10/2014 - 10:49

Still getting same error index:1 size:0

by JeyaKarthik N R Author

Posted on Wed, 12/10/2014 - 11:20

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");

by Eva Klein

Posted on Wed, 12/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());

by JeyaKarthik N R Author

Posted on Thu, 12/11/2014 - 07:50

Thanks Eva!!

Now it works perfect!.

by Sch J

Posted on Wed, 01/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

by Rahil Razac

Posted on Thu, 08/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

Merge Cells in EXCEL Reports

Featured achievement

Leaderboard

Follow us

View posts by tag