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
Write py file
from xlwt import * import StringIO from apps.song.models import Song def excel_ktvsong(request): """ 导出excel表格 """ _id = request.GET.get('id', 0) list_obj = Song.objects.filter(is_delete__exact=False) # django orm if list_obj: # 创建工作薄 ws = Workbook(encoding='utf-8') 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='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("无数据")
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!