django Framework Template based Generation of excel of xls Files Example
- 2021-06-29 11:18:09
- OfStack
This article provides an example of how the django framework generates excel (xls) files based on templates.Share it for your reference, as follows:
To generate Excel files, many people use a number of open source libraries, such as the csv library that comes with python to generate something like Excel 1. Of course, there are also some libraries dedicated to excel that I've used before, such as here: //www.ofstack.com/article/163408.htm I've described using a third-party library.But there is actually another way, the template approach.
Although the title is written using the django template, in fact, and 1 certain, you can be a custom text file.This file only needs to be written in a certain format. It's in xml format. I wrote several tags in my project, which I can test after removing:
Template Content
{% load languageTag %}
{% load mulTag%}
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>wh</Author>
<LastAuthor>wuhf</LastAuthor>
<Created>2011-05-10T03:11:52Z</Created>
<LastSaved>2011-05-11T03:09:09Z</LastSaved>
<Company>ig</Company>
<Version>11.9999</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>10290</WindowHeight>
<WindowWidth>21600</WindowWidth>
<WindowTopX>0</WindowTopX>
<WindowTopY>285</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Center"/>
<Borders/>
<Font ss:FontName=" Song Style " x:CharSet="134" ss:Size="12"/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s21">
<Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
</Style>
<Style ss:ID="s24">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
</Style>
<Style ss:ID="s25">
<NumberFormat ss:Format="Short Date"/>
</Style>
<Style ss:ID="s26">
<NumberFormat/>
</Style>
<Style ss:ID="s27">
<NumberFormat ss:Format=""US$"#,##0.00;\-"US$"#,##0.00"/>
</Style>
<Style ss:ID="s28">
<Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="s29">
<Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
<NumberFormat/>
</Style>
<Style ss:ID="s30">
<Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
<NumberFormat ss:Format=""US$"#,##0.00;\-"US$"#,##0.00"/>
</Style>
</Styles>
<Worksheet ss:Name="Sheet1">
<Table ss:ExpandedColumnCount="11" ss:ExpandedRowCount="{{count_data}}" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25">
<Column ss:AutoFitWidth="0" ss:Width="83.25"/>
<Column ss:Index="3" ss:Width="90"/>
<Column ss:Index="6" ss:Width="63"/>
<Column ss:Index="10" ss:Width="57"/>
<Column ss:Width="69.75"/>
<Row ss:AutoFitHeight="0">
<Cell ss:MergeAcross="10" ss:StyleID="s21"><Data ss:Type="String">{%if filter.phase == 'week'%}{%padLang 3_week_report%} {%else%} {%padLang 3_month_report%} {%endif%}</Data></Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:MergeAcross="10" ss:StyleID="s21"><Data ss:Type="String">{%padLang 3_pay_date%} : {{filter.start_date}} - {{filter.end_date}} </Data></Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:StyleID="s21"/>
<Cell ss:StyleID="s21"/>
<Cell ss:StyleID="s21"/>
<Cell ss:StyleID="s21"/>
<Cell ss:StyleID="s21"/>
<Cell ss:StyleID="s21"/>
<Cell ss:StyleID="s21"/>
<Cell ss:StyleID="s21"/>
<Cell ss:StyleID="s21"/>
<Cell ss:StyleID="s21"/>
<Cell ss:StyleID="s21"/>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:MergeAcross="6" ss:StyleID="s24"><Data ss:Type="String">{%padLang 3_order_info%}</Data></Cell>
<Cell ss:MergeAcross="3" ss:StyleID="s24"><Data ss:Type="String">{%padLang 3_pay_info%}</Data></Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell><Data ss:Type="String">{%padLang 3_order_sn%}</Data></Cell>
<Cell><Data ss:Type="String">{%padLang 3_user_name%}</Data></Cell>
<Cell><Data ss:Type="String">{%padLang 3_distributor_name%}</Data></Cell>
<Cell><Data ss:Type="String">{%padLang 3_amount%}</Data></Cell>
<Cell><Data ss:Type="String">{%padLang 3_amount_source%}</Data></Cell>
<Cell><Data ss:Type="String">{%padLang 3_create_date%}</Data></Cell>
<Cell><Data ss:Type="String">{%padLang 3_installment%}</Data></Cell>
<Cell><Data ss:Type="String">{%padLang 3_pay_name%}</Data></Cell>
<Cell><Data ss:Type="String">{%padLang 3_amount_local%}</Data></Cell>
<Cell><Data ss:Type="String">{%padLang 3_amount_amr%}</Data></Cell>
<Cell><Data ss:Type="String">{%padLang 3_pay_date%}</Data></Cell>
</Row>
{%for phase,orders in res.iteritems%}
{%for order_sn,order_pays in orders.iteritems%}
{%for item in order_pays%}
{%if forloop.first %}
<Row ss:AutoFitHeight="0">
<Cell><Data ss:Type="String">{{item.order_sn}}</Data></Cell>
<Cell><Data ss:Type="String">{{item.user_name}}</Data></Cell>
<Cell><Data ss:Type="String">{{item.distributor_name}}</Data></Cell>
<Cell ss:StyleID="s27"><Data ss:Type="Number">{{item.order_subtotal}}</Data></Cell>
<Cell><Data ss:Type="String">{%if item.order_subtotal == 1%} {%padLang 3_user%}{%else%}{%padLang 3_distributor%}{%endif%}</Data></Cell>
<Cell ss:StyleID="s25"><Data ss:Type="String">{%if item.create_date == 0 %}{{item.pay_date.}}{%else%} {{item.create_date}} {%endif%}</Data></Cell>
<Cell><Data ss:Type="String">{%if item.installment_id%} {%padLang 3_yes%}{%else%} {%padLang 3_no%}{%endif%}</Data></Cell>';
{%else%}
<Row ss:AutoFitHeight="0">
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="s25"></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
{%endif%}
<Cell><Data ss:Type="String">
{%if item.payment_id == '-2'%}{%padLang 3_amount_hand%}
{%else%}{%if item.payment_id == '0'%} {%else%}{{item.pay_name}}{%endif%}
{%endif%}
</Data></Cell>
<Cell ss:StyleID="s26"><Data ss:Type="String">{{item.pay_money}} {{item.rate_name}}</Data></Cell>
<Cell ss:StyleID="s27"><Data ss:Type="Number">{{item.amr}}</Data></Cell>
<Cell ss:StyleID="s25"><Data ss:Type="DateTime">{{item.pay_date}}</Data></Cell>
</Row>
{%endfor%}
{%endfor%}
<Row ss:AutoFitHeight="0">
<Cell ss:StyleID="s28"><Data ss:Type="String">{%padLang 3_subtotal%}</Data></Cell>
<Cell ss:StyleID="s28"/>
<Cell ss:StyleID="s28"/>
<Cell ss:StyleID="s28"/>
<Cell ss:StyleID="s28"/>
<Cell ss:StyleID="s28"/>
<Cell ss:StyleID="s28"/>
<Cell ss:StyleID="s28"/>
<Cell ss:StyleID="s29"/>
<Cell ss:StyleID="s30"><Data ss:Type="Number">{{item.phase_subtotal}}</Data></Cell>
<Cell ss:StyleID="s28"/>
</Row>
{%endfor%}
<Row ss:AutoFitHeight="0">
<Cell><Data ss:Type="String">{%padLang 3_total%}</Data></Cell>
<Cell ss:Index="10" ss:StyleID="s27"><Data
ss:Type="Number">{{total}}</Data></Cell>
</Row>
</Table>
</Worksheet>
</Workbook>
This template contains some of my own logic, people familiar with django can see at a glance that those I added, those that should have been, in fact, the reason is that circular processing < cell > and < row > Fill it in.
What to do in the view:
def report_pad_order(request):
....
t = TemplateResponse(request, 'pad_order_report_xls.html', context)
t.render()
response = HttpResponse(content_type='application/vnd.ms-excel')
response['Content-Disposition'] = 'attachment; filename=test.xls'
response.write(t.content)
return response
This allows you to download excel documents directly from the Django rendering template.It is also convenient to generate excel at least without calling many three-party API functions.
I hope that the description in this paper will be helpful to everyone's Python program design based on the Django framework.