Skip to main content

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

Project details


Release history Release notifications

This version
History Node

0.1.1

History Node

0.1

Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
django-export-xls-0.1.1.linux-i686.exe (68.0 kB) Copy SHA256 hash SHA256 Windows Installer any Oct 31, 2013
django-export-xls-0.1.1.tar.gz (3.2 kB) Copy SHA256 hash SHA256 Source None Oct 31, 2013

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page