Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

A simple Django app to export data to an excel file.

Project Description

Django Export XLS is a simple Django app to export data to a xls file.

Detailed documentation is in the “docs” directory on github https://github.com/Daiech/django-export-xls

Instalation

  1. Install from PyPi:

    $ pip install django-export-xls
    

Quick start

  1. Add “export_xls” to your INSTALLED_APPS setting like this:

    INSTALLED_APPS = (
        ...
        'export_xls',
    )
    
  2. Be sure to have the MEDIA_ROOT and MEDIA_URL vars defined. eg:

    import os
    MEDIA_ROOT = os.sep.join([os.path.dirname(os.path.dirname(__file__)), 'media'])
    MEDIA_URL = '/media/'
    
  3. The only thing that you must to do is create an excel file is:

    * Define a name for your file
    * Define a Python list with the fields you want in your excel (xls headers).
    * Create a python list with the values ​​you want to add to your xls file.
    

How to use

  • Import the function:

    from export_xls.views import export_xlwt
    
  • ‘export_xlwt’ function needs:

   3 mandatory parameters:

filename
fields
values_list

  2 optional parameters:

save   : save the xls file on settings.MEDIA_ROOT
folder : save the xls file on settings.MEDIA_ROOT/folder
  • ‘export_xlwt’ function return the string:

    MEDIA_URL + folder + filename
    eg: /media/xls/filename.xls
    

Example

from export_xls.views import export_xlwt return export_xlwt(filename, fields, values_list, save=True, folder=”xls/”)

view the real example. Clone de github repo:

  git clone https://github.com/Daiech/django-export-xls
  cd django-export-xls/example
  python manage.py runserver


Credentians for database:

  * user: daiech
  * pass: 1
Release History

Release History

This version
History Node

0.1.1

History Node

0.1

Download Files

Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
django-export-xls-0.1.1.linux-i686.exe (68.0 kB) Copy SHA256 Checksum SHA256 any Windows Installer Oct 31, 2013
django-export-xls-0.1.1.tar.gz (3.2 kB) Copy SHA256 Checksum SHA256 Source Oct 31, 2013

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting