This isn’t too bad …right ?
Not too tired but would rather be sleeping now. Unfortunately I have to finish this chapter before Sunday.. sighs deeply 2:53:05 AM
# USAGE python sheetinverter.py import logging import openpyxl import os import sys logging.basicConfig(level=logging.DEBUG, format="%(asctime)s - %(levelname)s - %(message)s") if len(sys.argv) == 2: # TODO: EXTRACT WB wb = sys.argv[1] wb = os.path.abspath(wb) try: workbook = openpyxl.load_workbook(wb) # TODO: GET ACTIVE SHEET active = workbook.get_active_sheet() if not active: logging.error("Excel Workbook should have at least a sheet") raise if active.max_row <= 0 or active.max_column <= 0: logging.error("Excel Workbook should have a sheet with data") raise # TODO: CREATE NEW SHEET # TODO: RE-NAME THE NEW SHEET invert = workbook.create_sheet("Inverted") # TODO: LOOP THROUGH ACTIVE SHEET AND UPDATE NEW SHEET for row in range(1, active.max_row): for col in range(1, active.max_column): invert.cell(row=col, column=row).value = active.cell( row=row, column=col).value workbook.save(wb) workbook.close() except Exception as err: logging.error("Error at opening workbook: " + str(err)) else: logging.error("USAGE python sheetinverter.py ")
*Pats back*