Awesome Python Packet

openpyxl

def out_xls(request,name):
    template_file_name = os.path.join(base_path,'_webodt','templates','graduaction.xlsx')
    out_file_name = os.path.join(base_path,'_webodt','outputs','graduaction.xls')

    wb = load_workbook(template_file_name)
    sheet = wb.active

    sheet_head = sheet['A1']
    sheet_head_template = unicode(sheet_head.value)
    sheet['A1'] = sheet_head_template.format(term='2016', college=u'经济管理学院')

    for index in range(4,101):
        cell_mark = 'A'+str(index)
        cell = sheet[cell_mark]
        cell.alignment = Alignment(horizontal="center", vertical="center")
        side = Side(border_style='thin',color='FF000000')
        cell.border = Border(left=side,right=side,top=side,bottom=side)
        cell.font = Font(name='SimSun', size=10)
        cell.value = index

    wb.save(out_file_name)
    return down_file(out_file_name)