set_external_workbook method

set_external_workbook

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

def set_external_workbook(self, workbook_path):
    ...
ParameterTypeDescription
workbook_pathstrPath to the target workbook

Exceptions

ExceptionDescription
RuntimeError(Proxy error(InvalidOperationException))External workbook is not available or can’t be loaded.

set_external_workbook

Sets external workbook as a data source for the chart.

def set_external_workbook(self, workbook_path, update_chart_data):
    ...
ParameterTypeDescription
workbook_pathstrPath to the target workbook
update_chart_databoolIf 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.

Exceptions

ExceptionDescription
RuntimeError(Proxy error(InvalidOperationException))External workbook is not available or can’t be loaded.

See Also