Read and Manipulate Excel 2016 Charts

Possible Usage Scenarios

Aspose.Cells supports the reading and manipulation of Microsoft Excel 2016 charts, which are not present in Microsoft Excel 2013 or earlier versions.

Read and Manipulate Excel 2016 Charts

The following sample code loads the sample Excel file which contains Excel 2016 charts in the first worksheet. It reads all charts one by one and changes their titles according to each chart’s type. The following screenshot shows the sample Excel file before the execution of the code. As you can see, the chart title is the same for all charts.

The following screenshot shows the output Excel file after the execution of the code. As you can see, the chart titles are changed according to each chart’s type.

Sample Code

Console Output

Here is the console output of the above sample code when executed with the provided sample Excel file.

Waterfall

Treemap

Sunburst

Histogram

BoxWhisker