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

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

JeyaKarthik N R on December 5, 2014

Hi guys,

I want to publish a excel sheet with top row freezed (which means even when I scroll down the top row is always visible and will not get scrolled)

Is there any way do like this in ARIS?

Tags: #arisreportscripting

Bookmark

Notify Moderator

3 Replies

Ariene Kroeze on December 5, 2014 - 11:37

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;

}