pip install xlwt

from xlwt import *import StringIOfrom apps.song.models import Songdef excel_ktvsong(request):?  """?導(dǎo)出excel表格?"""?  _id = request.GET.get('id', 0)?  list_obj = Song.objects.filter(is_delete__exact=False)? # django orm    if list_obj:? # 創(chuàng)建工作薄?    ws = Workbook(encoding='utf-8')?    w = ws.add_sheet(u"歌曲列表")?    w.write(0, 0, u"歌曲名稱")?    w.write(0, 1, u"歌手")?    # 寫入數(shù)據(jù)?    excel_row = 1?    for obj in list_obj:?      data_song = obj.song?      data_singer_name = obj.singer_name?      w.write(excel_row, 0, data_song)?      w.write(excel_row, 1, data_singer_name)??      excel_row += 1??    sio = StringIO.StringIO()?    ws.save(sio)?    sio.seek(0)?    response = HttpResponse(sio.getvalue(),         content_type='application/vnd.ms-excel')?    response['Content-Disposition'] = 'attachment;filename=%s.xls' % time.strftime('%Y%m%d%H%M%S')?    response.write(sio.getvalue())?    return response?  else:?    return HttpResponse("無數(shù)據(jù)")