Importing data from a local Excel file

Another popular format for storing tabular data is an Excel spreadsheet. In this recipe, we will import movies from a file of this format.

Getting ready

Let's start with the movies app that we created in the previous recipe. Install the openpyxl package to read Excel files, as follows:

(project_env)$ pip3 install openpyxl~=2.5.0

How to do it...

Follow these steps to create and use a management command that imports movies from a local XLSX file:

1. If you haven't done so, in the movies app, create a management directory...