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. [sourcecode language=”python”] #USAGE python sheet2text.py <EXCELFILE> import logging, sys, os, 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 […]

Coding

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

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     [sourcecode language=”python”] #USAGE python sheetinverter.py <WB> import logging, openpyxl, os,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 […]