How to create EXCEL Sheet With the help of Script..?

You can create a new Excel document via report like this:

var xlsWorkbook = Context.createExcelWorkbook(Context.getSelectedFile());
var oSheet = xlsWorkbook.createSheet("MySheetName");
    oSheet.setColumnWidth(nColumn, 20000);
    ....
    
    
Or you can use an existing Excel template (store it beside your report script)

    var xlsTemplateData = Context.getFile("MyExcelTemplate.xlsx", Constants.LOCATION_SCRIPT);
    var xlsWorkbook = Context.createExcelWorkbook("MyExcelTemplate.xlsx", xlsTemplateData);
    var aSheets = xlsWorkbook.getSheets();
    ....
    var oSheet = xlsWorkbook.createSheet("MySheetName");

Dear Krishna,

To gain more experience in creating reports check out our ARIS scripting tutorials :-).

Kind regards
Eva