Tag: excel

Coding

Python Learning: Automate Boring Stuff with Python | Chapter 12: Spreadsheet to Text Files

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): […]

Coding

Python Learning: Automate Boring Stuff with Python | Chapter 12: Text Files to Spreadsheet

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 […]

Coding

Python Learning: Automate Boring Stuff with Python | Chapter 12: Spreadsheet cell Inverter 2020

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 […]