How to freeze panes (header row) in excel report using ARIS?

function XLS_SetFreezePane(psFileLocation, pArray){

    // pArray [x] [0]= sheetnr,

    // pArray [x] [1] =  col

    // pArray [x] [2] = row

    // eg::

    // XLS_SetFreezePane(filename,  [[0,3,1],[1,1,1],[2,0,1],[3,0,1]]);     

      

    var lBool2Return = false;

     

    //var lsFileLocation= Files_GetCorrectFileName(psFileLocation);

    var lsFileLocation= psFileLocation;

//    if (Files_Exists(lsFileLocation)){



        var lHSSFWorkBook = new Packages.POI.HSSFWorkbook(new Packages.java.io.FileInputStream(lsFileLocation));

        for (var i in pArray){

            var lSheetNr = pArray[i][0];

            var lColNr = pArray[i][1];

            var lRowNr = pArray[i][2];            

            

            if (lSheetNr>-1){

                try{

                    lHSSFWorkBook.getSheetAt(lSheetNr).createFreezePane((lColNr * 1), (lRowNr*1));

                    lHSSFWorkBook.getSheetAt(lSheetNr).createFreezePane((lColNr * 1), (lRowNr*1));

                }catch(ex){}

            }else{

                for (var j=0;j<lHSSFWorkBook.getNumberOfSheets();j++){

                    try{

                        lHSSFWorkBook.getSheetAt(j).createFreezePane((lColNr * 1), (lRowNr*1));

                    }catch(ex){}

                }

            }

       }

       lHSSFWorkBook.write(new Packages.java.io.FileOutputStream(lsFileLocation));

       lBool2Return = true;

//    }     

    return lBool2Return;

}

 

success, br, Ariene Kroeze

Hi, Im not able to use this code after copying it to my report script.  Could you please give some more directions?

Many thanks in advance