/django-export-xls

Django export XLS

Primary LanguagePythonBSD 3-Clause "New" or "Revised" LicenseBSD-3-Clause

=================
Django Export XLS
=================

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

eg::

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


Example
-------

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

更新日志(2022.12.08):::
      * 支持1.7版本以上的Django
      * 修复export_xlwt返回值错误

------
支持网站:  
http://nai.dog