How to Create Excel file with Images and Trigger to Download in Django.

This Article is contains how we can attach the images in excel sheet and trigger to download the same in django project.

Packages we need ..

Install   :  pip install xlsxwriter

Dont Forget To import the following packages in your views

from django.shortcuts import render
from django.http import HttpResponse
from excel_response import ExcelResponse
import datetime as date_time
from django.utils.html import strip_tags
import io
from xlsxwriter.workbook import Workbook
import urllib2
import base64

Here "Product" Is model

@login_required
def download_excel(request,p_id):

    if p_id:
        output = io.BytesIO()
        workbook = Workbook(output, {'in_memory': True})
        bold = workbook.add_format({'bold': True})
        worksheet = workbook.add_worksheet()
        merge_format = workbook.add_format({
           'bold': 1,
           'border': 1,
           'align': 'center',
           'valign': 'vcenter',
           'fg_color': 'yellow'})
        product = Product.objects.get(id=p_id)
        worksheet.merge_range('A2:M2',"Product Name :"+product.name, merge_format)
        heading = ['ProductName','Product Upc','category','Manufacturer','Brand',\
                   'Product Style Number','Length','Width','Height','Weight','Color',\
                   'Size','Description']
        for counter,head in enumerate(heading):
            worksheet.write(4,counter,head,merge_format)
        category = product.category.all()
        for cat in category:
            cat_name = cat.name
            colour = []
        for clr in product.color.all():
            cr = clr.color
            colour.append(cr)
        size = []
        for si in product.size.all():
            s = si.size
            size.append(s)
        html = product.description
        discription = strip_tags(html)
        content = [product.name,product.upc,\
                   cat_name,product.brand.manufacturer.name,\
                   product.brand.name,product.style_number,\
                   product.length +':'+product.length_mi,\
                   product.width +':'+product.length_mi,\
                   product.height+':'+product.length_mi,\
                   product.weight+':'+product.weight_mi,\
                   colour,size,discription]
        for counter,data in enumerate(content):
            worksheet.write(6,counter,''.join(data))
            worksheet.write(4,13,'NetWork Price',merge_format)
            worksheet.write(6,13,product.network_price)
            worksheet.write('A10:M10', 'Product Images:',merge_format)
        gallery = []
        row = 7
        col = 0
        for image in product.gallery.all():
            url = settings.SITE_URL + image.image_thumbnail.url
            image_data = io.BytesIO(urllib2.urlopen(url).read())
            gallery.append(image_data)
        for counter,image in enumerate(gallery):
            row += 10+counter
        worksheet.insert_image(row,col, url, {'image_data': image,'x_offset': 15, 'y_offset': 10})
        workbook.close()
        output.seek(0)
        response = HttpResponse(output.read(), content_type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
        response['Content-Disposition'] = "attachment; filename=%s.xlsx" %product.upc
    return response