saving and dwnloading excel file in django

-

 

import pandas as pd
import os
import openpyxl
import xlwt


def Category1_excel(request):
    #saving file 
category1=Download.objects.all()
file=[]

for i in category1:
p=i.column1
s=i.column2
q=i.column3
row=[p,s,q,e,l]
file.append(row)

document = pd.DataFrame(file)
document.to_excel('media/file_downloads/category1.xlsx')
    
    #downloading file
    category1=Download.objects.all()
response = HttpResponse(content_type='application/ms-excel')
response['Content-Disposition'] = 'attachment; filename="file.xls"'
wb = xlwt.Workbook(encoding='utf-8')
ws = wb.add_sheet("sheet1")
font_style = xlwt.XFStyle()
font_style.font.bold = True

row_num = 0
ws.write(row_num, 0,'PURCHASED GOODS', font_style)
ws.write(row_num, 1, 'SUPPLIER', font_style)
ws.write(row_num, 2, 'QUANTITY PURCHASED', font_style)
ws.write(row_num, 3, 'SUPPLIER EMISSION', font_style)
ws.write(row_num, 4, 'LOCATION', font_style)

for my_row in category1:
row_num = row_num + 1
ws.write(row_num, 0, my_row.Purchased_good, font_style)
ws.write(row_num, 1, my_row.Supplier, font_style)
ws.write(row_num, 2, my_row.Quantity_purchased, font_style)
ws.write(row_num, 3, my_row.Supplier_emision, font_style)
ws.write(row_num, 4, my_row.Location, font_style)
wb.save(response)
return response



 

Comments

Post a Comment

Popular posts from this blog

How to solve Server Error (500) when I set Debug - False (Django Heroku )

-
  Here are the steps that worked for me: step 0:  In your command line, go to your project directory (where manage.py exists) Step 1: pip install whitenoise      make sure this library is added  to the requirements.txt ( pip freeze > requirements.txt) Step 2:   go to your settings.py folder and locate MIDDLEWARE. add 'whitenoise.middleware.WhiteNoiseMiddleware' ,   Step 3: in the same settings.py add STATIC_ROOT = os.path.join(BASE_DIR, 'static') for my case it was just above django_heroku.settings(locals()) Step 4: now go to your wsgi.py file in the same directory as settings.py type the following at the top from whitenoise import WhiteNoise also at the bottom you will use the import so add application = WhiteNoise(application)   Step 5:  now change DEBUG = False and go back to the command prompt in the project directory Step 6: type python manage.py collectstatic after this a new folder will appear in the root directory of yo...
Read more

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 ):                   ...
Read more

C PROGRAMMING LANGUAGE

-
PART 1: OPERATORS IN C LANGUAGE OPERATORS IN C LANGUAGE An operator is a symbol that operates on a value or a variable. For example: + is an operator to perform addition. C has a wide range of operators to perform various operations. Relational Operators Logical Operators Assignment Operator Decrement and increment Comma Operator sizeof Operator C Arithmetic Operators An arithmetic operator performs mathematical operations such as addition, subtraction, multiplication, division etc on numerical values (constants and variables). Operator Meaning of Operator + addition or unary plus - subtraction or unary minus * Multiplication / Division % remainder after division (modulo division) C Increment and Decrement Operators C programming has two operators increment ++ and decrement -- to change the value of an operand (constant or variable) by 1. Increment ++ increases the value by 1 whereas decrement -- decreases the value by 1. These two operators are unary operators, meaning the...
Read more