SpreadJS Documentation
Setting the Top Row and Column
SpreadJS Documentation > Sample Code > Sample Code for Rows and Columns > Setting the Top Row and Column

You can specify the row and column at the top of the widget.

Using Code

This example sets the top row and column.

JavaScript
Copy Code
$("#button1").click(function () {
    var activeSheet = spread.getActiveSheet();
    activeSheet.showRow(9, GC.Spread.Sheets.VerticalPosition.top);
});

$("#button2").click(function(){
    var activeSheet = spread.getActiveSheet();
    activeSheet.showColumn(9, GC.Spread.Sheets.HorizontalPosition.left);
});