直接上代码:
def download(request): # 从数据库查询数据 data_list = Info.objects.all() # 定义返回对象 response = HttpResponse() # 给返回对象定义解析类型 response['Content-Type'] = 'csv' # 声明一个csv的响应 response['Content-Disposition'] = 'attachment;filename="data.csv"' # csv的响应编码格式声明 response.write(codecs.BOM_UTF8) # 把响应设置成文件句柄 writer_obj = csv.writer(response) # 先写入表格头 writer_obj.writerow(["姓名", "年龄", "地址"]) # 写入数据 for info in data_list: writer_obj.writerow([info.name, info.age, info.address]) return response
参考1:
https://www.cnblogs.com/haoshine/p/5695760.html
import csv import codecs import datetime from django.db import connection from django.contrib.auth.models import User from django.http import HttpResponse from models import * def output(request, user_id, node_id, function_id): function_id = int(function_id) user_id = int(user_id) node_id= int(node_id) # 指定csv请求回应 response = HttpResponse(content_type='text/csv') user = User.objects.get(id=user_id) functions_has_permission = DataPermission.objects.filter(category=node_id) # 取出sql语句 function_obj = DataPermission.objects.get(id=function_id) function_obj_sql = function_obj.sql # 执行sql语句,并执行。保存执行结果和字段名 cursor = connection.cursor() cursor.execute(function_obj_sql) results = cursor.fetchall() descriptions = cursor.description descriptions_long = len(descriptions) description_list = [None] * descriptions_long i = 0 for description in descriptions: description_list[i] = description[0] i = i + 1 # 将执行结果从元组形式转化为列表形式。 i=0 results_long = len(results) results_list = [None] * results_long for i in range(results_long): results_list[i] = list(results[i]) # print(results_list) # 为文件取名字 now = datetime.datetime.now() now = str(now.isoformat()) name = (now + '.csv').replace(':', '') # 声明一个csv的响应 response['Content-Disposition'] = 'attachment; filename="%s"' % name # csv的响应的编码格式声明 response.write(codecs.BOM_UTF8) writer = csv.writer(response) # 转码问题 a = u'中' for result in results_list: i=0 for item in result: if type(item) == type(a): # 如果是unicode类型,那么编码成utf-8 result[i] = item.encode('utf-8') i = i + 1 # with open(response, 'wb') as f: writer.writerow(description_list) for result in results_list: writer.writerow(result) i = i + 1 response.close() return response
导出的文件,中文如果显示成乱码
解决方法:将上面代码中的'utf-8' 改成 'gb2312'
result[i] = item.encode('gb2312')
参考2:
抽取数据库文件: def exportmysql(request): conn= MySQLdb.connect( host='192.168.137.3', port = 3306, user='root', passwd='1234567', db ='DEVOPS', charset='UTF8' ) cur = conn.cursor() a = cur.execute("select ip,info,env from machine_info") info = cur.fetchall() response = HttpResponse(content_type='text/csv') response['Content-Disposition'] = 'attachment; filename="somefilename.csv"' writer = csv.writer(response) for row in info: writer.writerow(row) return response
参考3:
最近一个用django开发的web项目要进行数据的导入导出,所以有必要了解下。
django中主要用HttpResponse将请求结果返回给浏览器,所以文件的下载也是通过改对象进行处理的,具体的一个列子的代码如下:
[python] view plain copy #文件下载 def download(request): """ Send a file through Django without loading the whole file into memory at once. The FileWrapper will turn the file object into an iterator for chunks of 8KB. """ #读取mongodb的文件到临时文件中 fileid_=request.GET["fileid"] filepath_ = ('%s/%s'%(MEDIA_ROOT, fileid_)) #文件全路径 file_=TFiles.objects.get(fileid=int(fileid_)) filename_=file_.filename filetype_=file_.filetype if os.path.isfile(filepath_): pass else: mongoLoad(fileid_) #下载文件 def readFile(fn, buf_size=262144):#大文件下载,设定缓存大小 f = open(fn, "rb") while True:#循环读取 c = f.read(buf_size) if c: yield c else: break f.close() response = HttpResponse(readFile(filepath_), content_type='APPLICATION/OCTET-STREAM') #设定文件头,这种设定可以让任意文件都能正确下载,而且已知文本文件不是本地打开 response['Content-Disposition'] = 'attachment; filename='+filename_.encode('utf-8') + filetype_.encode('utf-8')#设定传输给客户端的文件名称 response['Content-Length'] = os.path.getsize(filepath_)#传输给客户端的文件大小 return response
=====================
Python+Django实现文件的下载
HttpResponse, StreamingHttpResponse, FileResponse
https://blog.csdn.net/li627528647/article/details/77544136