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


Download files

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

Files for django-export-xls, version 0.1.1
Filename, size File type Python version Upload date Hashes
Filename, size django-export-xls-0.1.1.linux-i686.exe (68.0 kB) File type Windows Installer Python version any Upload date Hashes View hashes
Filename, size django-export-xls-0.1.1.tar.gz (3.2 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

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