锁定前三行的代码如下:
activeSheet.SetFreezeRow(3);
锁定前三列的代码如下:
activeSheet.SetFreezeCol(3);
锁定前三行三列的代码如下:
activeSheet.SetFreeze('C3');
完整的代码例子如下:
let wsheet = new websheet('myofdID', yourElement);
/**
* 第一步 获取激活的activeSheet
*/
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++);
/**
* 第二步 锁定行列
*/
//锁定前3行
// activeSheet.SetFreezeRow(3);
//锁定前3列
//activeSheet.SetFreezeCol(3);
//锁定前C3列
activeSheet.SetFreeze('C3');
/**
* 第三步 重新绘制表格
*/
wsheet.BuildSheet();
wsheet.Draw();
结果如下: