SpreadJS 13
SpreadJS Documentation / Sample Code / Sample Code for Cells / Getting Selected Ranges
In This Topic
    Getting Selected Ranges
    In This Topic

    You can get the ranges of multiple selected areas.

    Using Code

    This example gets the selected ranges.

    JavaScript
    Copy Code
    window.onload = function()
    {
       var spread = 
       new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
       var activeSheet = spread.getActiveSheet();
       activeSheet.setRowCount(5);
       activeSheet.setColumnCount(5);
       $("#button1").click(function()
       {       
         // Acquiring selection ranges
         var selectedRanges = spread.getActiveSheet().getSelections();
         for(var i = 0; i < selectedRanges.length; i++)
            {
                 console.log("---------------------------");
                 console.log("Using Range class");
                 console.log("-------------------------");
                 console.log("Selected top row index: " + selectedRanges[i].row);
                 console.log("Number of selected rows: " + selectedRanges[i].rowCount);
                 console.log("Selected first column index: " + selectedRanges[i].col);
                 console.log("Number of selected columns: " + selectedRanges[i].colCount);
             }
       });
    }
    
    See Also

    Developer's Guide