from openpyxl import Workbook
from openpyxl.utils import get_column_letter

wb = Workbook()
dest_filename = "balances_template.xlsx"

ws1 = wb.active
ws1.title  =  "range anmes"

for row in range(1,40):
    ws1.title = "range names"
    ws1.append(range(600))

ws2 =  wb.create_sheet(title="Pi")
ws2["F5"] = 3.14

ws3 = wb.create_sheet(title="Data")
for row in range(10,20):
    for col in range(27,54):
        _ = ws3.cell(column=col, row=row, value="{0}".format(get_column_letter(col)))
        print(ws3["AA10"].value)
wb.save(filename=dest_filename)


# read an existing workbook
from openpyxl import Workbook
from openpyxl import load_workbook

wb = load_workbook(filename= "balances_template.xlsx")
sheet_ranges = wb["range names"]
print(sheet_ranges["D18"].value)

# using number formats
import datetime
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
# set date using a py datetime
ws["A1"] = datetime.datetime(2021,2,20) # now(yyyy-mm-dd hh:mm:ss)

print(ws["A1"].number_format)
# yyyy-mm-dd h:mm:ss

# using formulae
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
# add a simple formula
ws["A1"] = "=SUM(1,1)"
wb.save("formula.xlsx")

# FORMULAE
from openpyxl.utils import FORMULAE
print("HEX2DEC" in FORMULAE)

# merge / unmerge cells


