Example of python exporting data to excel-Python Tutorial-php.cn

Example of python exporting data to excel

不言

Release： 2018-05-03 11:54:07

Original

9767 people have browsed it

This article mainly introduces the example of exporting data to excel in python. It has certain reference value. Now I share it with you. Friends in need can refer to it.

This article is under the django framework. To write and obtain data from the database, django-orm

is used to export data to excel using python. It is so simple! (Ordinary excel format)

Install xlwt

pip install xlwt

Copy after login

Write py file

from xlwt import *
import StringIO
from apps.song.models import Song
def excel_ktvsong(request): 
  """ 导出excel表格 """ 
  _id = request.GET.get(&#39;id&#39;, 0) 
  list_obj = Song.objects.filter(is_delete__exact=False)  # django orm  
  if list_obj:  # 创建工作薄 
    ws = Workbook(encoding=&#39;utf-8&#39;) 
    w = ws.add_sheet(u"歌曲列表") 
    w.write(0, 0, u"歌曲名称") 
    w.write(0, 1, u"歌手") 
    # 写入数据 
    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=&#39;application/vnd.ms-excel&#39;) 
    response[&#39;Content-Disposition&#39;] = &#39;attachment;filename=%s.xls&#39; % time.strftime(&#39;%Y%m%d%H%M%S&#39;) 
    response.write(sio.getvalue()) 
    return response 
  else: 
    return HttpResponse("无数据")

Copy after login

Related recommendations:

Use python to implement data analysis

Detailed explanation of Python implementation of database programming method

The above is the detailed content of Example of python exporting data to excel. For more information, please follow other related articles on the PHP Chinese website!