Create MS Excel Files using Python – Python Excel API

Create Excel Files in Python

Python has become one of the ruling programming languages in the past few years. The usefulness and popularity of Python have immensely grown the community of Python enthusiasts. On the other hand, spreadsheet automation has made it easier to keep, organize, and play with a large amount of data from within the web or desktop applications. This article aims to put together Python and spreadsheet automation to show you how to create Excel XSLX or XLS files using Python. Furthermore, you will learn how to insert data, images, charts, and tables in an Excel worksheet programmatically using Python.

Python API to Create Excel XLSX/XLS Files – Free Download

Aspose.Cells for Python via Java is a powerful yet easy to use spreadsheet manipulation API that lets you implement spreadsheet automation within your applications using Python. You can create new Excel files as well as update and convert existing spreadsheet documents in a few lines of code. In order to integrate and use Aspose.Cells for Python via Java, execute the following pip command.

  • pip install aspose-cells

You can also download the API’s package from the downloads section.

Create Excel XLSX/XLS Files using Python

Let’s start by creating a simple Excel XLSX file using Aspose.Cells for Python via Java. The following are the steps to do this:

The following code sample shows how to create an Excel XLSX file using Python.

Output

create excel file using python

Python Code to Insert Data into an Excel File

In the previous example, you have created a new Excel XLSX file from scratch. However, there might be the case when you need to update the content of an existing Excel file. In this case, you can load the Excel file by providing its path to the Workbook constructor. The rest of the methods for accessing the worksheets and cells will remain the same.

The following code sample shows how to update an Excel file using Python.

Output

update excel file in python

Create Excel File having Images using Python

In both of the previous examples, you have seen how to insert or update text in the cells of Excel worksheets. Let’s now check out how to insert an image into the worksheet using Python.

The following code sample shows how to create an Excel file and insert an image using Python.

Output

insert image in excel using python

Generate Charts within Excel Worksheet using Python

Charts in Excel worksheets are used to visually represent the data in the form of histograms, pyramids, bars, doughnuts and etc. Aspose.Cells for Python via Java supports a multitude of chart types that are listed here. The following are the steps to generate a chart within an Excel worksheet.

The following code sample shows how to generate charts in an Excel worksheet using Python.

Output

create chart in excel using python

Create Pivot Tables in Excel Worksheet using Python

Pivot tables in Excel are created to summarize a large amount of data within the worksheets. You can specify the range of the cells to be used in the pivot table. The following are the steps to create a pivot table using Aspose.Cells for Python via Java.

The following code sample shows how to create a pivot table in Excel using Python.

create pivot table in excel using python

Get a Free API License

You can use Aspose.Cells for Python Java without evaluation limitations by getting a free temporary license.

Conclusion

In this article, you have seen how to create Excel files from scratch using Python. Furthermore, you have learned how to insert data, images, charts, and pivot tables within Excel worksheets programmatically. You can learn more about Aspose’s Python Excel API using the documentation.

See Also