此文是在django框架下編寫(xiě)，從數(shù)據(jù)庫(kù)中獲取數(shù)據(jù)使用的是django-orm

用python導(dǎo)出數(shù)據(jù)到excel，簡(jiǎn)單到爆！（普通的excel格式）

安裝xlwt

pip install xlwt

編寫(xiě)py文件

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"歌曲名稱(chēng)")
    w.write(0, 1, u"歌手")
    # 寫(xiě)入數(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("無(wú)數(shù)據(jù)")

以上這篇python實(shí)現(xiàn)數(shù)據(jù)導(dǎo)出到excel的示例--普通格式就是小編分享給大家的全部?jī)?nèi)容了，希望能給大家一個(gè)參考，也希望大家多多支持武林站長(zhǎng)站。