Coding

Python Learning: Automate Boring Stuff with Python | Chapter 11 : My Solution to Multiplication Table Maker

Easier done than said ….like actually

03:35:23 Coffee with a drop of sleep in my eyes


I am rather tired at the moment but have enough energy to solve this task: Multiplication table challenge..

[sourcecode language=”python”]

#Usage: python multiplication.py <N>

import sys, os, openpyxl,logging
from openpyxl.styles import Font

logging.basicConfig(level=logging.DEBUG, format="%(asctime)s – %(levelname)s – %(message)s")

if len(sys.argv) == 2:
limit = int(sys.argv[1])
filename = os.path.join(".", "multiplication{}.xlsx".format(limit) )
#TODO: create xlsx
wb = openpyxl.Workbook()
sheet = wb.get_active_sheet()
if not sheet:
wb.create_sheet(title="Multiplication Table")
sheet = wb.get_active_sheet()
fontObj = Font(bold=True)
#TODO:print first row
topRow = list(range(1, limit +1))
topRow = [" "] + topRow
i = 1
for val in topRow:
curr_cell = sheet.cell(row=1, column=i)
curr_cell.font = fontObj
curr_cell.value = val
i+=1
#create table
i = 1
for row in range(1, limit + 1):
cur = sheet.cell(row=row +1, column=1)
cur.font = fontObj
cur.value = row
for col in range(1, limit + 1):
sheet.cell(row=row +1, column=col+1).value = row * col
i+=1
wb.save(filename)
else:
logging.error("Usage: python multiplication.py <N>")<span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span>

[/sourcecode]

I expected this to be perplexing but was an enjoyable process.

Please follow and like us:
0

Enjoy this blog? Please spread the word :)

error: Content is protected !!