django_excel_templates Generate Excel Tables from Django
Download

django_excel_templates Ranking & Summary

django_excel_templates Tags

template system Django templates Django plugin Excel Excel documents

django_excel_templates Description

Generate Excel Tables from Django django_excel_templates is a Django plugin that aims to create a template system for generation of the Excel documents for views (instead of HTML).Simple case: Sniff model and make a excel table Medium case: "" "" and apply predetermined styles (fonts, colors, layout) Advanced case: Take models and set custom styles or modify existing Professional case: Set styles based on cross sections of models, tally totals, formula support, graphs, and sub-tables based on manytomany or foreign keys.To Install DocumentationGet Epydoc ( we used verion xxxx)./epydocd djan ...Installation: python setup.py installExamples: testobj is django.db.models.query.QuerySet instanceBasic: from django_excel_templates import * report = ExcelReport() report.nextsheet("TestBasic") report.add_one_instance(testobj,REPORT_HORZ,True,style=None)Medium (create style, one by one): report.nextsheet("TestStyle") style = ExcelStyle() style.set_font(font_color='000000',bold=True,italic=True) style.set_border(border_color='000000',border_style=5) style.set_pattern(pattern_color='339933',pattern=1) report.add_one_instance(testobj,REPORT_HORZ,True,style=style)Medium (create style all at once): report.nextsheet("TestStyle2") style2 = ExcelStyle(font_color='00FF00',shadow=True,underline=True,pattern_color='000000',pattern=1,border_style=5,border_color='FFFFFF') report.add_one_instance(testobj,REPORT_HORZ,True,style=style2)Advanced: report.nextsheet("ModifyStyle") style.set_font(font_color='000000',bold=False,underline=True) style.set_border(border_color='330099',border_style=6) style.set_pattern(pattern_color='FFFFFF',pattern=1) report.add_one_instance(testobj,REPORT_HORZ,True,style=style) Requirements: · Python · Django · xlwt

django_excel_templates Related Software