Read and Manipulate Excel 2016 Charts
Contents
[
Hide
]
Possible Usage Scenarios
Aspose.Cells for Python via .NET now 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 source excel file which contains Excel 2016 charts in the first worksheet. It reads all charts one by one and changes its title as per its chart type. The following screenshot shows the source excel file before the execution of code. As you can see, chart title is same for all charts.
The following screenshot shows the output excel file after the execution of code. As you can see, the chart title is changed as per its chart type.
Sample Code
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import Workbook | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # The path to the documents directory. | |
| dataDir = RunExamples.GetDataDir(".") | |
| # Load source excel file containing excel 2016 charts | |
| book = Workbook(dataDir + "excel2016Charts.xlsx") | |
| # Access the first worksheet which contains the charts | |
| sheet = book.worksheets[0] | |
| # Access all charts one by one and read their types | |
| for i in range(len(sheet.charts)): | |
| # Access the chart | |
| ch = sheet.charts[i] | |
| # Print chart type | |
| print(ch.type) | |
| # Change the title of the charts as per their types | |
| ch.title.text = "Chart Type is " + str(ch.type) | |
| # Save the workbook | |
| book.save(dataDir + "out_excel2016Charts.xlsx") |
Console Output
Here is the console output of the above sample code when executed with the provided source excel file.
Waterfall
Treemap
Sunburst
Histogram
BoxWhisker