Product Family

Create Area Charts via Python

Native and high performance MS Excel Charts creation programmatically using Python APIs.

Creating Area Charts dynamically within running application is easy. In order to create variety of charts to spreadsheets from scratch without requiring MS Office, we’ll use Aspose.Cells for Python API that offers different features for spreadsheets creation, manipulation and conversion on Python platform. Aspose.Cells provides many flexible chart objects.

How to Create Area Charts via Python

It is easy for the developers to create an Area chart within running different reporting applications for data processing in just a few lines of code.

  1. Import asposecells in your code file.
  2. Create Workbook class instance.
  3. Add some data to worksheet.
  4. Add an Area chart to the worksheet
  5. Access the new chart object from the Charts collection by passing its index.
  6. Set the chart’s data source with Chart.setChartDataRange method.
  7. Save as Excel or ODS files.

System Requirements

Aspose.Cells for Python is platform-independent API and can be used on any platform (Windows, Linux and MacOS), just make sure that system have Java 1.8 or higher, Python 3.5 or higher.

- Install Java and add it to PATH environment variable, for example: PATH=C:\Program Files\Java\jdk1.8.0_131;. - Install Aspose.Cells for Python from pypi, use command as: $ pip install aspose-cells.

Following source code shows how to create an Area Chart to MS Excel XLSX file using Python.