How to save and download a csv file in django

-

 

import pandas as pd
 
def Category1_csv(request):

category1=Database.objects.all()
file=[]

for i in category1:
p=i.abc
row=[p,...]
file.append(row)
    #to save a file
document = pd.DataFrame(file)
document.to_csv('media/file_downloads/category1.csv')
#return HttpResponse("file createrd")
    # to download a file
data = open(os.path.join(settings.BASE_DIR,'media/file_downloads/category1.csv'),'r').read()
resp =HttpResponse(data)
resp['Content-Disposition'] = 'attachment;filename=csv file.csv'
return resp


 

Comments

Post a Comment

Popular posts from this blog

Exporting HTML Page into PDF In Django

-
Views.py from django.shortcuts import render from io import BytesIO from django.http import HttpResponse from django.template.loader import get_template from xhtml2pdf import pisa   from django.views import generic import pandas as pd # Create your views here. # defining the function to convert an HTML file to a PDF file def html_to_pdf ( template_src , context_dict ={}):      template = get_template(template_src)      html  = template.render(context_dict)      result = BytesIO()      pdf = pisa.pisaDocument(BytesIO(html.encode( "ISO-8859-1" )), result)       if not pdf.err:           return HttpResponse(result.getvalue(), content_type = 'application/pdf' )       return None class GeneratePdf ( generic . View ):       def get ( self , request , * args , ** kwargs ):                   # getting the template         pdf = html_to_pdf( 'app/dashboard/climate_risk.html' )                     # rendering the template         return HttpRespons
Read more