¶ I. Row Freeze
The code to lock the first three rows is as follows:
activeSheet.SetFreezeRow(3);
¶ II. Column Freeze
The code to lock the first three columns is as follows:
activeSheet.SetFreezeCol(3);
¶ III. Row and Column Freeze
The code to lock the first three rows and three columns is as follows:
activeSheet.SetFreeze('C3');
¶ IV. Code Example
The complete code example is as follows:
let wsheet = new websheet('myofdID', yourElement);
/**
* Step 1: Get the active sheet
*/
let activeSheet = wsheet.ActiveSheet();
let i=1;
activeSheet.SetCellValue(3,i,i++);
activeSheet.SetCellValue(3,i,i++);
activeSheet.SetCellValue(3,i,i++);
activeSheet.SetCellValue(3,i,i++);
activeSheet.SetCellValue(3,i,i++);
activeSheet.SetCellValue(3,i,i++);
activeSheet.SetCellValue(3,i,i++);
activeSheet.SetCellValue(3,i,i++);
activeSheet.SetCellValue(3,i,i++);
activeSheet.SetCellValue(3,i,i++);
let r=1;
activeSheet.SetCellValue(r,3,r++);
activeSheet.SetCellValue(r,3,r++);
activeSheet.SetCellValue(r,3,r++);
activeSheet.SetCellValue(r,3,r++);
activeSheet.SetCellValue(r,3,r++);
activeSheet.SetCellValue(r,3,r++);
activeSheet.SetCellValue(r,3,r++);
activeSheet.SetCellValue(r,3,r++);
activeSheet.SetCellValue(r,3,r++);
activeSheet.SetCellValue(r,3,r++);
/**
* Step 2: Lock rows and columns
*/
// Lock the first 3 rows
// activeSheet.SetFreezeRow(3);
// Lock the first 3 columns
// activeSheet.SetFreezeCol(3);
// Lock the first C3 cell
activeSheet.SetFreeze('C3');
/**
* Step 3: Redraw the table
*/
wsheet.BuildSheet();
wsheet.Draw();
The result is as follows:
