Skip to Content
ClassesFSparkline

类: FSparkline

The facade class for the sparkline.

方法

changeDataSource()

changeDataSource(sourceRange, targetRange): FSparkline;

参数

参数类型描述
sourceRangeIRangeLocation of new data source
targetRangeIRangeNew placement

返回

FSparkline

Return this, for chaining

Description

Modify the data source of the sparkline in the current cell

示例

const fWorkbook = univerAPI.getActiveWorkbook(); const fWorksheet = fWorkbook.getActiveSheet(); // Create a sparkline in the range A10, with the data source in the range A1:A7. const sparkline = fWorksheet.addSparkline( [fWorksheet.getRange('A1:A7').getRange()], [fWorksheet.getRange('A10').getRange()] ); // Modify the data source of the sparkline to the range B1:B7, and move it to the range B10 after 3 seconds. setTimeout(() => { sparkline.changeDataSource( fWorksheet.getRange('B1:B7').getRange(), fWorksheet.getRange('B10').getRange() ); }, 3000);

removeSparkline()

removeSparkline(): void;

返回

void

Description

Delete the sparkline in the current cell

示例

const fWorkbook = univerAPI.getActiveWorkbook(); const fWorksheet = fWorkbook.getActiveSheet(); // Create a sparkline in the range A10, with the data source in the range A1:A7. const sparkline = fWorksheet.addSparkline( [fWorksheet.getRange('A1:A7').getRange()], [fWorksheet.getRange('A10').getRange()] ); // Remove the sparkline after 3 seconds. setTimeout(() => { sparkline.removeSparkline(); }, 3000);