Chapter 12 done!!! Finally
Now I can sleep.. for 10 minutes though.. 3:42:14 AM
Suggestions are welcomed.
# USAGE python sheet2text.py import logging import sys import os import openpyxl logging.basicConfig(level=logging.DEBUG, format="%(asctime)s - %(levelname)s - %(message)s") if len(sys.argv) == 2: # TODO: EXTRACTS EXCEL FILE excelfile = sys.argv[1] excelfile = os.path.abspath(excelfile) excelfile_name = os.path.basename(excelfile).split(".")[0] if not os.path.exists(excelfile): logging.error("Excel File " + excelfile + " does not exists") raise # TODO: OPENS FILE wb = openpyxl.load_workbook(excelfile) # TODO: GET ACTIVE SHEET ws = wb.active if not ws: logging.error("Excel File should have at least a sheet with data") raise if ws.max_row <= 0 or ws.max_column <= 0: logging.error("Excel File should contain data") raise # TODO: LOOP OVER COLUMNS # Each column = a new file; thus for col in range(1, ws.max_column + 1): # TODO: CREATE NEW TEXT FILES newFile = open(excelfile_name + "_column" + str(col) + ".txt", "a") # read each row for row in range(1, ws.max_row): data = ws.cell(column=col, row=row).value if not data: data = "" # ensure all values ( including ints) are strings data = str(data) + "\n" newFile.write(data) newFile.close wb.close() else: logging.error("USAGE python sheet2text.py ")