automatically provides for new workbooks (the number of default sheets created may vary between operating systems and spreadsheet programs figure - the tabs for workbook' sheets are in the lower-left corner of excel sheet in the example file should look like table - (if you didn' download example xlsx from the websiteyou should enter this data into the sheet yourself table - the example xlsx spreadsheet : : pm apples : : am cherries : : pm pears : : am oranges : : am apples : : pm bananas : : am strawberries now that we have our example spreadsheetlet' see how we can manipulate it with the openpyxl module opening excel documents with openpyxl once you've imported the openpyxl moduleyou'll be able to use the openpyxl load_workbook(function enter the following into the interactive shellimport openpyxl wb openpyxl load_workbook('example xlsx'type(wbthe openpyxl load_workbook(function takes in the filename and returns value of the workbook data type this workbook object represents the excel filea bit like how file object represents an opened text file remember that example xlsx needs to be in the current working directory in order for you to work with it you can find out what the current working directory is by importing os and using os getcwd()and you can change the current working directory using os chdir(working with excel spreadsheets