How To Install python3-xlsxwriter on Ubuntu 20.04

In this tutorial we learn how to install python3-xlsxwriter on Ubuntu 20.04. python3-xlsxwriter is Python 3 module for creating Excel XLSX files

Introduction

In this tutorial we learn how to install python3-xlsxwriter on Ubuntu 20.04.

What is python3-xlsxwriter

python3-xlsxwriter is:

XlsxWriter is a Python module for writing files in the Excel 2007+ XLSX file format.

XlsxWriter can be used to write text, numbers, formulas and hyperlinks to multiple worksheets and it supports features such as formatting and many more, including:

  • 100% compatible Excel XLSX files
  • Full formatting
  • Merged cells
  • Defined names
  • Charts
  • Autofilters
  • Data validation and drop down lists
  • Conditional formatting
  • Worksheet PNG/JPEG images
  • Rich multi-format strings

This is the Python 3 version of the package.

There are three methods to install python3-xlsxwriter on Ubuntu 20.04. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install python3-xlsxwriter Using apt-get

Update apt database with apt-get using the following command.

sudo apt-get update

After updating apt database, We can install python3-xlsxwriter using apt-get by running the following command:

sudo apt-get -y install python3-xlsxwriter

Install python3-xlsxwriter Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install python3-xlsxwriter using apt by running the following command:

sudo apt -y install python3-xlsxwriter

Install python3-xlsxwriter Using aptitude

If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.

sudo aptitude update

After updating apt database, We can install python3-xlsxwriter using aptitude by running the following command:

sudo aptitude -y install python3-xlsxwriter

How To Uninstall python3-xlsxwriter on Ubuntu 20.04

To uninstall only the python3-xlsxwriter package we can use the following command:

sudo apt-get remove python3-xlsxwriter

Uninstall python3-xlsxwriter And Its Dependencies

To uninstall python3-xlsxwriter and its dependencies that are no longer needed by Ubuntu 20.04, we can use the command below:

sudo apt-get -y autoremove python3-xlsxwriter

Remove python3-xlsxwriter Configurations and Data

To remove python3-xlsxwriter configuration and data from Ubuntu 20.04 we can use the following command:

sudo apt-get -y purge python3-xlsxwriter

Remove python3-xlsxwriter configuration, data, and all of its dependencies

We can use the following command to remove python3-xlsxwriter configurations, data and all of its dependencies, we can use the following command:

sudo apt-get -y autoremove --purge python3-xlsxwriter

References

Summary

In this tutorial we learn how to install python3-xlsxwriter package on Ubuntu 20.04 using different package management tools: apt, apt-get and aptitude.