python实现数据导出到excel的示例--普通格式
此文是在django框架下编写,从数据库中获取数据使用的是django-orm
用python导出数据到excel,简单到爆!(普通的excel格式)
安装xlwt
pip install xlwt
编写py文件
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("无数据")
相关推荐
86193952 2020-10-27
Mynamezhuang 2020-09-18
充满诗意的联盟 2020-08-23
raksmart0 2020-08-17
yfightfors 2020-08-16
84487600 2020-08-16
qdqht00 2020-07-26
WebVincent 2020-07-21
hzyuhz 2020-07-04
fengchao000 2020-07-04
javaraylu 2020-06-28
baijinswpu 2020-06-28
ZHANGRENXIANG00 2020-06-28
Teamomc 2020-06-28
Catastrophe 2020-06-26
hell0kitty 2020-06-17
我欲疾风前行 2020-06-18