Django 3 Web Development Cookbook - Fourth Edition

How it works...

The principle of importing from an XLSX file is the same as with CSV. We open the file, read it row by row, form data dictionaries, validate them via a model form, and create the Song objects from the provided data.

Again, we are using the prepare(), main(), and finalize() methods to split the logic into more atomic parts.

Here is a detailed explanation of the main() method as it is probably the only different part of the management command:

• Excel files are workbooks containing sheets as different tabs.
• We are using the openpyxl library to open a file passed as a positional argument to the command. Then, we read the first sheet from the workbook.
• The first row contains the column captions. We skip it.
• Afterward, we will read ...