# Using the openpyxl module, write a program that reads all the Excel files in the
# current working directory and outputs them as CSV files.
# A single Excel file might contain multiple sheets; you’ll have to create one CSV
# file per sheet. The filenames of the CSV files should be
# <excel filename>_<sheet title>.csv, where <excel filename> is the filename of the
# Excel file without the file extension (for example, 'spam_data', not
# 'spam_data.xlsx') and <sheet title> is the string from the Worksheet object’s title
# variable.
#
# Note:
# - Example Excel files can be downloaded from http://nostarch.com/automatestuff/

for excelFile in os.listdir('.'):
    # Skip non-xlsx files, load the workbook object.
    for sheetName in wb.get_sheet_names():
        # Loop through every sheet in the workbook.
        sheet = wb.get_sheet_by_name(sheetName)

        # Create the CSV filename from the Excel filename and sheet title.
        # Create the csv.writer object for this CSV file.

        # Loop through every row in the sheet.
        for rowNum in range(1, sheet.get_highest_row() + 1):
            rowData = []    # append each cell to this list
            # Loop through each cell in the row.
            for colNum in range(1, sheet.get_highest_column() + 1):
                # Append each cell's data to rowData.

            # Write the rowData list to the CSV file.

        csvFile.close()
@@ -623,16 +623,37 @@
 stuff/%0A%0A
+import openpyxl, os%0A%0A
 for exce
@@ -759,25 +759,18 @@
  wb.
-get_
 sheet
-_
 names
-()
 :%0A  
@@ -841,27 +841,10 @@
 = wb
-.get_sheet_by_name(
+%5B'
 shee
@@ -848,17 +848,18 @@
 heetName
-)
+'%5D
 %0A%0A      
@@ -1074,25 +1074,15 @@
 eet.
-get_highest
+max
 _row
-()
  + 1
@@ -1238,28 +1238,18 @@
 eet.
-get_highest
+max
 _column
-()
  + 1

Update excelToCSV added imports and changed depreciated methods