1 hour laturr…..

I need coffee but if I drink coffee, I will go to sleep… drinks green tea instead 3:18:41 AM


Improvements are welcomed!

#USAGE python text2sheet <Several text files seperated by space>


import logging, sys, os, 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 <Several text files seperated by space>")
	raise<span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span>

 

 

One task left before the chapter ends! Yeaa

Just need more green tea… resist the coffee
Please follow and like us:
0

Enjoy this blog? Please spread the word :)

error: Content is protected !!