类: FWorksheet

activate(): FWorksheet

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheets = fWorkbook.getSheets();
// activate the last sheet
fWorkSheets[fWorkSheets.length - 1].activate();

addConditionalFormattingRule(rule): FWorksheet

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
const fRange = fWorksheet.getRange('A1:T100');
const rule = fWorksheet.newConditionalFormattingRule()
  .whenCellNotEmpty()
  .setRanges([fRange.getRange()])
  .setItalic(true)
  .setBackground('red')
  .setFontColor('green')
  .build();
fWorksheet.addConditionalFormattingRule(rule);

addFloatDomToColumnHeader(
   column, 
   layer, 
   domPos, 
   id?): Nullable<{
  dispose: ...;
  id: ...;
}>

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
 
// Register a float button component
const FloatButton = () => {
  const divStyle = {
    width: '100px',
    height: '30px',
    backgroundColor: '#fff',
    border: '1px solid #ccc',
    boxSizing: 'border-box' as const,
    display: 'flex',
    justifyContent: 'center',
    alignItems: 'center',
    textAlign: 'center' as const,
    cursor: 'pointer',
  };
 
  const clickHandler = () => {
    console.warn('click');
  };
 
  return (
    <div style={divStyle} onClick={clickHandler}>
      FloatButton
    </div>
  );
};
univerAPI.registerComponent('FloatButton', FloatButton);
 
// Add the float button to the column D header, position is right align, width is 100px, height is 30px, margin is 0
const disposeable = fWorksheet.addFloatDomToColumnHeader(3, {
  componentKey: 'FloatButton',
  allowTransform: false,
}, {
  width: 100,
  height: 30,
  marginX: 0,
  marginY: 0,
  horizonOffsetAlign: 'right',
}, 'myFloatButton');
 
// Remove the float button
setTimeout(() => {
  disposeable?.dispose();
}, 2000);

addFloatDomToPosition(layer, id?): Nullable<{
  dispose: ...;
  id: ...;
}>

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
 
// You should register components at an appropriate time (e.g., when Univer is loaded)
// This is a React component. For Vue3 components, the third parameter should be `{ framework: 'vue3' }`
univerAPI.registerComponent(
  'myFloatDom',
  ({ data }) => (
    <div style={{ width: '100%', height: '100%', background: '#fff', border: '1px solid #ccc', boxSizing: 'border-box' }}>
      popup content:
      {' '}
      {data?.label}
    </div>
  ),
);
 
// Add a floating DOM
// If disposable is null, floating DOM addition failed
const disposeable = fWorksheet.addFloatDomToPosition({
  componentKey: 'myFloatDom',
  initPosition: {
    startX: 100,
    endX: 300,
    startY: 100,
    endY: 200,
  },
 
  // Component data
  data: {
    label: 'hahah',
  },
});
 
// Remove the floating DOM
setTimeout(() => {
  disposeable?.dispose();
}, 2000);

addFloatDomToRange(
   range, 
   layer, 
   domLayout, 
   id?): Nullable<{
  dispose: ...;
  id: ...;
}>

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
 
// Register a range loading component
const RangeLoading = () => {
  const divStyle = {
    width: '100%',
    height: '100%',
    backgroundColor: '#fff',
    border: '1px solid #ccc',
    boxSizing: 'border-box' as const,
    display: 'flex',
    justifyContent: 'center',
    alignItems: 'center',
    textAlign: 'center' as const,
    transformOrigin: 'top left',
  };
 
  return (
    <div style={divStyle}>
      Loading...
    </div>
  );
};
univerAPI.registerComponent('RangeLoading', RangeLoading);
 
// Add the range loading component covering the range A1:C3
const range = fWorksheet.getRange('A1:C3');
const disposeable = fWorksheet.addFloatDomToRange(range, { componentKey: 'RangeLoading' }, {}, 'myRangeLoading');
 
setTimeout(() => {
  disposeable?.dispose();
}, 2000);
 
// another example-------------------
// Register a float button component
const FloatButton = () => {
  const divStyle = {
    width: '100px',
    height: '30px',
    backgroundColor: '#fff',
    border: '1px solid #ccc',
    boxSizing: 'border-box' as const,
    display: 'flex',
    justifyContent: 'center',
    alignItems: 'center',
    textAlign: 'center' as const,
    cursor: 'pointer',
  };
 
  const clickHandler = () => {
    console.warn('click');
  };
 
  return (
    <div style={divStyle} onClick={clickHandler}>
      FloatButton
    </div>
  );
};
univerAPI.registerComponent('FloatButton', FloatButton);
 
// Add the float button to the range A5:C7, position is start from A5 cell, and width is 100px, height is 30px, margin is 100% of range width and height
const range2 = fWorksheet.getRange('A5:C7');
const disposeable2 = fWorksheet.addFloatDomToRange(range2, {
  componentKey: 'FloatButton',
}, {
  width: 100,
  height: 30,
  marginX: '100%', // margin percent to range width, or pixel
  marginY: '100%'
}, 'myFloatButton');

addSparkline(
   sourceRanges, 
   targetRanges, 
   type): FSparkline

const workbook = univerAPI.getActiveWorkbook();
const worksheet = workbook.getActiveSheet();
 
const sparkline = worksheet.addSparkline(
  [{ startRow: 0, endRow: 6, startColumn: 0, endColumn: 0 }],
  [{ startRow: 9, endRow: 9, startColumn: 0, endColumn: 0 }]
);
 
console.log('sparkline instance', sparkline);

autoFitRow(rowPosition, auto?): FWorksheet

const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet();
fWorkSheet.autoFitRow(24);

cancelFreeze(): FWorksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Cancel freeze
fWorksheet.cancelFreeze();

clear(options?): FWorksheet

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
// clear the sheet of content and formatting information
fWorkSheet.clear();
// clear the sheet of content only
fWorkSheet.clear({ contentsOnly: true });

clearComments(): Promise<boolean>

const workbook = univerAPI.getActiveWorkbook();
const worksheet = workbook.getSheetById(sheetId);
await worksheet.clearComments();

clearContents(): FWorksheet

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
// clear the sheet of content only
fWorkSheet.clearContents();

clearFormats(): FWorksheet

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
// clear the sheet of formatting only
fWorkSheet.clearFormats();

composeSparkline(ranges): void

const workbook = univerAPI.getActiveWorkbook();
const worksheet = workbook.getActiveSheet();
 
const firstSparkline = worksheet.addSparkline(
  [{ startRow: 0, endRow: 6, startColumn: 0, endColumn: 0 }],
  [{ startRow: 9, endRow: 9, startColumn: 0, endColumn: 0 }]
);
 
const secondSparkline = worksheet.addSparkline(
  [{ startRow: 0, endRow: 6, startColumn: 0, endColumn: 0 }],
  [{ startRow: 9, endRow: 9, startColumn: 1, endColumn: 1 }]
);
 
// There will be two sparklines here
const allSparklineBeforeCompose = worksheet.getAllSubSparkline();
 
worksheet.composeSparkline([{ startRow: 9, endRow: 9, startColumn: 0, endColumn: 1 }]);
 
// After compose, there will only be one sparkline
const allSparklineAfterCompose = worksheet.getAllSubSparkline();
console.log('debugger', allSparklineBeforeCompose, allSparklineAfterCompose);

createConditionalFormattingRule(): FConditionalFormattingBuilder

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
const fRange = fWorksheet.getRange('A1:T100');
const rule = fWorksheet.createConditionalFormattingRule()
  .whenCellNotEmpty()
  .setRanges([fRange.getRange()])
  .setItalic(true)
  .setBackground('red')
  .setFontColor('green')
  .build();
fWorksheet.addConditionalFormattingRule(rule);

customizeColumnHeader(cfg): void

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
fWorksheet.customizeColumnHeader({
	headerStyle: {
		fontColor: '#fff',
		backgroundColor: '#4e69ee',
		fontSize: 9
	},
	columnsCfg: {
		0: 'kuma II',
		3: {
			text: 'Size',
			textAlign: 'left', // CanvasTextAlign
			fontColor: '#fff',
			fontSize: 12,
			borderColor: 'pink',
			backgroundColor: 'pink',
		},
		4: 'Wow'
	}
});

customizeRowHeader(cfg): void

univerAPI.customizeRowHeader({
	headerStyle: {
		backgroundColor: 'pink',
		fontSize: 12
	},
	rowsCfg: {
		0: 'MokaII',
		3: {
			text: 'Size',
			textAlign: 'left'
		}
	}
});

deleteColumn(columnPosition): FWorksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Delete column C
fWorksheet.deleteColumn(2);
// Delete column A
fWorksheet.deleteColumn(0);

deleteColumns(columnPosition, howMany): FWorksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Delete 3 columns at column index 2 (columns C, D, E)
fWorksheet.deleteColumns(2, 3);
// Delete 1 column at column index 0 (column A)
fWorksheet.deleteColumns(0, 1);

deleteConditionalFormattingRule(cfId): FWorksheet

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
const rules = fWorksheet.getConditionalFormattingRules();
fWorksheet.deleteConditionalFormattingRule(rules[0]?.cfId);

deleteImages(sheetImages): FWorksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const image = fWorksheet.getImages()[0];
fWorksheet.deleteImages([image]);

deleteRow(rowPosition): FWorksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Delete the third row
fWorksheet.deleteRow(2);
// Delete the first row
fWorksheet.deleteRow(0);

deleteRows(rowPosition, howMany): FWorksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Delete 3 rows at row index 2 (rows 3-5)
fWorksheet.deleteRows(2, 3);
// Delete 1 row at row index 0 (first row)
fWorksheet.deleteRows(0, 1);

equalTo(other): boolean

const fWorkbook = univerAPI.getActiveWorkbook();
const sheets = fWorkbook.getSheets();
const fWorkSheet = fWorkbook.getActiveSheet();
console.log(fWorkSheet.equalTo(sheets[0])); // true, if the active sheet is the first sheet.

getActiveImages(): FOverGridImage[]

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const images = fWorksheet.getActiveImages();
images.forEach((image) => {
  console.log(image, image.getId());
});

getActiveRange(): FRange

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get the currently active range
const activeRange = fWorksheet.getActiveRange();
if (activeRange) {
  console.log('Active range:', activeRange.getA1Notation());
}

getAllSubSparkline(): Map<string, ISparklineGroup>

const workbook = univerAPI.getActiveWorkbook();
const worksheet = workbook.getActiveSheet();
 
const allSparkline = worksheet.getAllSubSparkline();
console.log('allSparkline', allSparkline);

getCellMergeData(row, column): FRange

const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet();
const merge = fWorkSheet.getCellMergeData(0, 0);
if (merge) {
  console.log('Merged range:', merge.getA1Notation());
}

getCharts(): FChart[]

const fWorkbook = univerAPI.getActiveWorkbook();
const fSheet = fWorkbook.getActiveSheet();
const charts = fSheet.getCharts();
console.log(charts.length); //chart count

getColumnCustomMetadata(index): CustomData

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
const custom = fWorkSheet.getColumnCustomMetadata(0);
console.log(custom);

getColumnDefaultStyle(index, keepRaw?): string | Nullable<...>

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get default style for column 0 (A)
const colStyle = fWorksheet.getColumnDefaultStyle(0);
console.log(colStyle);
// Get raw style data for column 0
const rawColStyle = fWorksheet.getColumnDefaultStyle(0, true);
console.log(rawColStyle);

getCommentById(commentId): FThreadComment

getComments(): FThreadComment[]

const workbook = univerAPI.getActiveWorkbook();
const worksheet = workbook.getSheetById(sheetId);
const comments = worksheet.getComments();

getConditionalFormattingRules(): IConditionFormattingRule[]

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
const rules = fWorksheet.getConditionalFormattingRules();
console.log(rules);

getDataRange(): FRange

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
// Assume the sheet is a empty sheet
const cellRange = fWorkSheet.getRange('J50');
cellRange.setValue('Hello World');
console.log(fWorkSheet.getDataRange().getA1Notation()); // A1:J50

getDataValidation(ruleId): Nullable<FDataValidation>

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
const rules = fWorksheet.getDataValidations();
console.log(fWorksheet.getDataValidation(rules[0]?.rule.uid));

getDataValidations(): FDataValidation[]

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
const rules = fWorksheet.getDataValidations();
console.log(rules);

getDefaultStyle(): string | Nullable<...>

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const defaultStyle = fWorksheet.getDefaultStyle();
console.log(defaultStyle);

getDefinedNames(): FDefinedName[]

// The code below gets all the defined names in the worksheet
const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const definedNames = fWorksheet.getDefinedNames();
console.log(definedNames);

getFilter(): FFilter

const workbook = univerAPI.getActiveWorkbook();
const worksheet = workbook.getActiveSheet();
const filter = worksheet.getFilter();
console.log(filter, filter?.getRange().getA1Notation());

getFreeze(): IFreeze

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get the freeze state of the current sheet
const freeze = fWorksheet.getFreeze();
console.log(freeze);

getFrozenColumnRange(): IColumnRange

const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get the range of the frozen columns
const frozenColumns = fWorkSheet.getFrozenColumnRange();
console.log(frozenColumns);

getFrozenColumns(): number

const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get the number of frozen columns
const frozenColumns = fWorkSheet.getFrozenColumns();
console.log(frozenColumns);

getFrozenRowRange(): IRowRange

const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get the range of the frozen rows
const frozenRows = fWorkSheet.getFrozenRowRange();
console.log(frozenRows);

getFrozenRows(): number

const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get the number of frozen rows
const frozenRows = fWorkSheet.getFrozenRows();
console.log(frozenRows);

getGridLinesColor(): string

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
// get the gridlines color of the sheet
console.log(fWorkSheet.getGridLinesColor());

getImageById(id): FOverGridImage

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const image = fWorksheet.getImageById('xxxx');
console.log(image);

getImages(): FOverGridImage[]

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const images = fWorksheet.getImages();
images.forEach((image) => {
  console.log(image, image.getId());
});

getIndex(): number

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
// get the position of the active sheet
const position = fWorkSheet.getIndex();
console.log(position);

getInject(): Injector

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const injector = fWorksheet.getInject();
console.log(injector);

getLastColumn(): number

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
// Assume the sheet is a empty sheet
const cellRange = fWorkSheet.getRange('J50');
cellRange.setValue('Hello World');
console.log(fWorkSheet.getLastColumn()); // 9

getLastColumns(): number

getLastRow(): number

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
// Assume the sheet is a empty sheet
const cellRange = fWorkSheet.getRange('J50');
cellRange.setValue('Hello World');
console.log(fWorkSheet.getLastRow()); // 49

getLastRows(): number

getMaxColumns(): number

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const totalColumns = fWorksheet.getMaxColumns();
console.log(`Sheet has ${totalColumns} columns`);

getMaxRows(): number

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const totalRows = fWorksheet.getMaxRows();
console.log(`Sheet has ${totalRows} rows`);

getMergeData(): FRange[]

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get all merged ranges in the sheet
const mergedData = fWorksheet.getMergeData();
// Process each merged range
mergedData.forEach(range => {
  console.log(range.getA1Notation());
});

getMergedRanges(): FRange[]

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get all merged ranges in the sheet
const mergedRanges = fWorksheet.getMergedRanges();
// Process each merged range
mergedRanges.forEach(range => {
  console.log(range.getA1Notation());
});

getRange(row, column): FRange

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get range for cell at row 0, column 0 (A1)
const range = fWorksheet.getRange(0, 0);
console.log(range);

getRange(
   row, 
   column, 
   numRows): FRange

getRange(
   row, 
   column, 
   numRows, 
   numColumns): FRange

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get range for cells A1:C3
const range = fWorksheet.getRange(0, 0, 3, 3);
console.log(range);

getRange(a1Notation): FRange

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get range for cells A1:C3
const range = fWorksheet.getRange("A1:C3");
console.log(range);
// Get range for a single cell
const cell = fWorksheet.getRange("B2");
console.log(cell);
// Get range with sheet name
const sheetName = fWorksheet.getSheetName();
const rangeWithSheet = fWorksheet.getRange(`${sheetName}!A1:C3`);
console.log(rangeWithSheet);

getRange(range): FRange

getRowCustomMetadata(index): CustomData

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
const custom = fWorkSheet.getRowCustomMetadata(0);
console.log(custom);

getRowDefaultStyle(index, keepRaw?): string | Nullable<...>

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Get default style for row 0 (1)
const rowStyle = fWorksheet.getRowDefaultStyle(0);
console.log(rowStyle);
// Get raw style data for row 0
const rawRowStyle = fWorksheet.getRowDefaultStyle(0, true);
console.log(rawRowStyle);

getScrollState(): IScrollState

univerAPI.getActiveWorkbook().getActiveSheet().getScrollState()

getSelection(): FSelection

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const selection = fWorksheet.getSelection();
console.log(selection);

getSheet(): Worksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const sheet = fWorksheet.getSheet();
console.log(sheet);

getSheetId(): string

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const sheetId = fWorksheet.getSheetId();
console.log(sheetId);

getSheetName(): string

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const sheetName = fWorksheet.getSheetName();
console.log(sheetName);

getSkeleton(): any

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
const skeleton = fWorksheet.getSkeleton();
console.log(skeleton);

getSparklineByCell(row, col): FSparkline

const workbook = univerAPI.getActiveWorkbook();
const worksheet = workbook.getActiveSheet();
const sparkline = worksheet.getSparklineByCell(9, 0)

getSparklineGroupByCell(row, col): FSparklineGroup

const workbook = univerAPI.getActiveWorkbook();
const worksheet = workbook.getActiveSheet();
const sparkline = worksheet.getSparklineGroupByCell(9, 0)

getTabColor(): string

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
// get the tab color of the sheet
console.log(fWorkSheet.getTabColor());

getUrl(): string

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
const url = fWorksheet.getUrl();
console.log(url);

getValidatorStatus(): Promise<ObjectMatrix<...>>

getValidatorStatusAsync(): Promise<ObjectMatrix<...>>

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
const status = await fWorksheet.getValidatorStatusAsync();
console.log(status);

getVisibleRange(): IRange

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
const visibleRange = fWorksheet.getVisibleRange();

getWorkbook(): Workbook

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
const workbook = fWorksheet.getWorkbook();
console.log(workbook);

getZoom(): number

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorksheet = fWorkbook.getActiveSheet();
const zoomRatio = fWorksheet.getZoom();
console.log(zoomRatio);

hasHiddenGridLines(): boolean

const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet();
// check if the gridlines are hidden
if (fWorkSheet.hasHiddenGridLines()) {
   console.log('Gridlines are hidden');
}

hideColumn(column): FWorksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Hide columns C, D, E
const column1 = fWorksheet.getRange('C:E');
fWorksheet.hideColumn(column1);
// Hide column A
const column2 = fWorksheet.getRange('A:A');
fWorksheet.hideColumn(column2);

hideColumns(columnIndex, numColumn?): FWorksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Hide columns C, D, E
fWorksheet.hideColumns(2, 3);
// Hide column A
fWorksheet.hideColumns(0, 1);

hideRow(row): FWorksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Hide 3 rows starting from row index 1 (rows 2-4)
const row1 = fWorksheet.getRange('2:4');
fWorksheet.hideRow(row1);
// Hide single row at index 0 (first row)
const row2 = fWorksheet.getRange('1:1');
fWorksheet.hideRow(row2);

hideRows(rowIndex, numRow?): FWorksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Hide 3 rows starting from row index 1 (rows 2-4)
fWorksheet.hideRows(1, 3);
// Hide single row at index 0 (first row)
fWorksheet.hideRows(0);

hideSheet(): FWorksheet

const fWorkbook = univerAPI.getActiveWorkbook();
const fWorkSheet = fWorkbook.getActiveSheet();
// hide the active sheet
fWorkSheet.hideSheet();

insertChart(chartBuildInfo): Promise<FChart>

const fWorkbook = univerAPI.getActiveWorkbook();
const fSheet = fWorkbook.getActiveSheet();
const chartInfo = fSheet.newChart()
  .addRange('A1:B8')
  .setChartType(ChartTypeBits.Column)
  .setPosition(1, 1, 0, 0)
  .build();
const fChart = await fSheet.insertChart(chartInfo);

insertColumnAfter(afterPosition): FWorksheet

const fWorksheet = univerAPI.getActiveWorkbook().getActiveSheet();
// Insert a column after column C
fWorksheet.insertColumnAfter(2);
// Insert a column after column A
fWorksheet.insertColumnAfter(0);

insertColumnBefore(beforePosition): FWorksheet