diff --git a/attendancebook_template.xlsx b/attendancebook_template.xlsx index 4505fa4..f425a28 100644 --- a/attendancebook_template.xlsx +++ b/attendancebook_template.xlsx Binary files differ diff --git a/call.cgi b/call.cgi index 243d058..bf8442a 100755 --- a/call.cgi +++ b/call.cgi @@ -188,10 +188,10 @@ for host, logon, logoff, _, _, student_no, name, reading, dep, pos, status in lines if host != None and host.startswith(prefix)] - ws.column_dimensions["A"].width =8.5; ws.column_dimensions["B"].width =11.0; - ws.column_dimensions["C"].width =7.0; ws.column_dimensions["D"].width =7.0; - ws.column_dimensions["E"].width =16.0; ws.column_dimensions["F"].width =18.0; - ws.column_dimensions["G"].width =14.0; ws.column_dimensions["H"].width =17.0; + ws.column_dimensions["A"].width =8.5; ws.column_dimensions["B"].width =10.0 + ws.column_dimensions["C"].width =7.0; ws.column_dimensions["D"].width =7.0 + ws.column_dimensions["E"].width =16.0; ws.column_dimensions["F"].width =18.0 + ws.column_dimensions["G"].width =17.8; ws.column_dimensions["H"].width =17.0 # setup width of each columns ws.append(["学生", "","","", fr.strftime("%Y/%m/%d"), fr.strftime("%H:%M")+"〜"+ to.strftime("%H:%M")]) @@ -235,7 +235,8 @@ ws['A'+row].alignment = align; ws['B'+row].alignment = align ws['C'+row].alignment = align; ws['D'+row].alignment = align ws['E'+row].alignment = align; ws['F'+row].alignment = align - ws['G'+row].alignment = align # TODO need refactor: maybe it can be integrated + ws['G'+row].alignment = align; ws['H'+row].alignment = align + # TODO need refactor: maybe it can be integrated if font: ws['A'+row].font = font; ws['B'+row].font = font ws['C'+row].font = font; ws['D'+row].font = font