Django 3 Web Development Cookbook - Fourth Edition

How to do it...

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

1. Create an XLSX file with the column names Artist, Title, and URL in the first row. Add some song data to it in the next rows matching the columns. You can do this in a spreadsheet application, by saving the CSV file from the previous recipe as an XLSX file, data/music.xlsx. Here is an example:

2. If you haven't done so, in the music app, create a management directory and then a commands subdirectory beneath it. Add empty __init__.py files in both of the new directories to make them Python packages.
3. Add an import_music_from_xlsx.py ...