跳到主要内容

GetActiveChart

Returns the active chart of the workbook.

Syntax​

expression.GetActiveChart();

expression - A variable that represents a ApiWorkbook class.

Parameters​

This method doesn't have any parameters.

Returns​

ApiChart | null

Example​

This example shows how to get currently active chart from the workbook

// const workbook = Api.GetActiveWorkbook();
// const worksheet = workbook.GetActiveSheet();
// worksheet.GetRange('A1').SetValue('John Smith');
// worksheet.GetRange('B1').SetValue('Mark Pottato');
// worksheet.GetRange('A2').SetValue(10);
// worksheet.GetRange('B2').SetValue(12);

// const chart = worksheet.AddChart('Sheet1!A1:B2', true, 'bar3D', 42, 100 * 36000, 70 * 36000, 2, 0, 2, 0);
// chart.SetTitle('Full Names Length', 15);

/*

Can not get active chart yet cuz chart.Select methods does not working

chart.Select();
const activeChart = workbook.GetActiveChart();

*/