old_contents: # Write a program that performs the tasks of the previous program in reverse
  # order: The program should open a spreadsheet and write the cells of column A
  # into one text file, the cells of column B into another text file, and so on.
  
new_contents: # Write a program that performs the tasks of the previous program in reverse
  # order: The program should open a spreadsheet and write the cells of column A
  # into one text file, the cells of column B into another text file, and so on.
  
  import openpyxl
  import os
  
  # Make directory
  FOLDER = "./p5files/"
  os.makedirs(FOLDER, exist_ok=True)
  
  # Open workbook
  wb = openpyxl.load_workbook("example.xlsx")
  sheet = wb.active
  
  # Open file
  index = 1
  while index <= sheet.max_column:
      fileObj = open(FOLDER + "text" + str(index) + ".txt", 'w')
      for rowNum in range(1, sheet.max_row + 1):
          # Transpose column into relevant text file
          fileObj.write(str(sheet.cell(row=rowNum, column=index).value) + '\n')
      index += 1
      fileObj.close()
  
subject: Update P5_excelToText working solution