setExternalWorkbook

setExternalWorkbook(String workbookPath) method

Sets external workbook as a data source for the chart. Chart data will be updated from the target workbook.

Parameters

NameTypeDescription
workbookPathStringPath to the target workbook

Returns

void

Exception

ExceptionCondition
InvalidOperationExceptionExternal workbook is not available or can’t be loaded.

setExternalWorkbook(String workbookPath, boolean updateChartData) method

Sets external workbook as a data source for the chart.

Parameters

NameTypeDescription
workbookPathStringPath to the target workbook
updateChartDatabooleanIf value is false only workbook path will be updated. Chart data won’t be loaded and updated from the target workbook. Can be used when target workbook doesn’t exist or it’s not available. If value is true chart data will be updated from the target workbook.

Returns

void

Exception

ExceptionCondition
InvalidOperationExceptionExternal workbook is not available or can’t be loaded.