def write_header(ws, univ, faculty, department, teacher, position): """Insert the header of the table""" ws.col(0).width = 6*256 for i in range(1, 12): ws.col(i).width = 15*256 dw.write(ws, 0, 0, univ) dw.write(ws, 0, 4, "Catedra " + department) dw.write(ws, 1, 0, faculty) dw.write(ws, 3, 2, "Orarul pentru") dw.write(ws, 3, 3, position + " " + teacher) dw.set_row_h(ws, 6, 3) dw.write(ws, 6, 0, "Ora", dw.boxed(2,1,1)) for i in range(0,5): ws.write_merge(6, 6, 2*i+1, 2*i + 2, ro_days[i], dw.faktup(2)) for i in range(0, 14): dw.write(ws, 7+i, 0, str(i+8)+":00", dw.boxed(1, 1, h_align = 2)) dw.set_row_h(ws, 7 + i, 3)
def insert_course(ws, i, courses):
j = 2*i + 1
h0 = 7
t = 0
loc = ()
for curs in courses:
a, b = curs['ore'].split("-")
h1 = int(a) - 1
h2 = int(b) - 1
if h0 < h1:
jump(ws, h0, h1, j)
if t > 1:
put_corner(ws, loc, t)
t = 0
if curs['parit'] == 2:
if curs['pari_st'] == 1:
ws.write(h1, j, curs['disciplina'] + " (" + curs ['tip'] + ") \n"
+ curs['grupa'] + " - " + curs['sala'], dw.half("up"))
t = 1
loc = (h1, j)
else:
ws.write(h2 - 1, j + 1, curs['disciplina'] + " (" + curs ['tip'] + ") \n"
+ curs['grupa'] + " - " + curs['sala'], dw.half("down"))
t += 2
loc = (h1, j)
else:
ws.write_merge(h1, h2 - 1, j, j + 1, curs['disciplina'] + " (" + curs ['tip'] + ") \n"
+ curs['grupa'] + " - " + curs['sala'], dw.faktup(2))
h0 = h2
if t > 1:
put_corner(ws, loc, t)
if h0 < 21:
jump(ws, h0, 21, j)
