1 hour laturr…..
I need coffee but if I drink coffee, I will go to sleep… drinks green tea instead 3:18:41 AM
Code
# USAGE python text2sheet import logging import sys import os import openpyxl logging.basicConfig(level=logging.DEBUG, format="%(asctime)s - %(levelname)s - %(message)s") if len(sys.argv) > 1: # TODO: EXTRACT TEXT FILES files = sys.argv[1:] # TODO:CREATE NEW WORKBOOK wb = openpyxl.Workbook() # TODO: CREATE NEW SHEET / GET ACTIVE SHEET ws = wb.active if not ws: ws = wb.create_sheet("Sheet1") # TODO: LOOP OVER FILE NUMBER for col in range(1, len(files) + 1): file = files[col - 1] file = os.path.abspath(file) # TODO: ERROR HANDLE FILE READING if not os.path.exists(file): logging.warning("File: " + file + " - does not exist") else: file = open(file) content = file.readlines() for row in range(1, len(content)): # TODO: UPDATE ROWS AND COLUMNS ws.cell(row=row, column=col).value = content[row - 1] logging.info("File: " + files[col - 1] + " - was added") file.close() wb.save("Text2Sheet.xlsx") wb.close() logging.info("Workbook closed") else: logging.error( "USAGE python text2sheet ")