In the How to do it… section, after importing the module in step 1, we create a new spreadsheet in step 2. This is a new spreadsheet that contains just the default sheet.
The data to be stored is defined in step 3. Note it contains the info that will go on both sheets (name in both, admissions in the first sheet, and director's name in the second). In this step, the first sheet is filled.
Note how the value is stored. The proper cell is defined as column A or B and the proper row (rows start at 1). The enumerate function returns a tuple with the first element as the index and the second as the enumerate parameter (an iterator).
After that, the new sheet is created in step 4, using the name Directors. .create_sheet returns the new sheet.
The information in the Directors sheet is stored in step 5 and the file is saved in step 6.