틀 고정

interface IFreeze {  /**   * The number of frozen columns   */  xSplit: number  /**   * The number of frozen rows   */  ySplit: number  /**   * The starting row that can be scrolled (the starting row of the main view area)   */  startRow: number  /**   * The starting column that can be scrolled (the starting column of the main view area)   */  startColumn: number}

{  "xSplit": 1, // Freeze 1 column, which is column B  "ySplit": 1, // Freeze 1 row, which is row 2  "startRow": 2, // The starting row that can be scrolled is row 3  "startColumn": 2 // The starting column that can be scrolled is column C}

const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()worksheet.setFreeze({  xSplit: 1, // Freeze 1 column, which is column B  ySplit: 1, // Freeze 1 row, which is row 2  startRow: 2, // The starting row that can be scrolled is row 3  startColumn: 2, // The starting column that can be scrolled is column C})console.log('The current freeze state:', worksheet.getFreeze())

const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()// Set freeze for columns A-Bworksheet.setFrozenColumns(2)

const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()// Set freeze for the first 3 rowsworksheet.setFrozenRows(3)

const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()const freezeState = worksheet.getFreeze()

const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()const frozenColumns = worksheet.getFrozenColumns()

const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()const frozenRows = worksheet.getFrozenRows()

const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()// Cancel all freezesworksheet.cancelFreeze()