Hi guys ,

I am facing error when 

var output = Context.createOutputObject(Constants.OutputXLSX,"Test_XLSX.xlsx")

09.output.BeginTable(100,Constants.C_BLACK,Constants.C_WHITE,Constants.FMT_LEFT | Constants.FMT_ITALIC,0);
10.
11.output.TableRow();
12.output.TableCell("iyerauth", 50, getString("ID_DEFAULT_FONT"), 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT, 0)
13 .output.TableCell("iyerauth", 50, getString("ID_DEFAULT_FONT"), 10, Constants.C_BLACK, Constants.C_RED, 0, Constants.FMT_LEFT, 0)
14.output.WriteReport()

Error:

Error running script:

Script:test_xlsx,line14

wrapped java.lang.NullPointerException(test_xlsx#14)

I want to have a background color for that particular cell. The error is thrown only if I give a color value (Constants.C_BLUE,Constants.C_RED,etc.), if I give C_TRANSPARENT no error is thrown.

I also tried for creating a style sheet using

output.createCellStyle() 

 function but when I do that I get error .."couldn't find function createCellStyle in output object"...
Can any one how to create a style sheet for the XLSX ouput 

Output Object = com.idsscheer.report.output.outputobject.excel.AExcelGenerator@e13ae5	

Thanks in advance!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

 

Tags: ARIS Architect ARIS Report Scripting ARIS script Reports script