We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to create and update the chart with external data range using XlsIO?

This article explains about creating and updating chart with external data range using XlsIO in C#/VB.NET

Is it possible to create or update chart with external data range?

No. It is not possible.

XlsIO does not have support for creating or updating data with external data range in XlsIO. However, we have provided a workaround to update the chart data from the external workbook.

To update the chart with external data range, you need to follow the below steps.

Steps to update chart with external data

  1. Open the input file which contains only and update the data manually.
  2. Then open both the Excel files containing data (DataWorkbook) and chart with data (ChartWorkbook) using XlsIO application.

 

  1. Get the data range from “DataWorkbook” and copy it to the “ChartWorkbook” in the chart’s data range.

 

  1. Save the Excel file contains chart. Now the data will be updated.
  2. Whenever the XlsIO application is executed, the chart data  range will be copied to “ChartWorkbook” and its chart will be updated.

 

To know more about charts in XlsIO, please refer the documentation.

Download input files

Download Complete Sample

The following C#/VB.NET complete code snippet shows how to update chart with external data range in XlsIO.

 

 

 

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8451 02/15/2018 02/15/2018 Windows Forms XlsIO
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon