wiki:ExcelDownloadPlugin

Download query output, reports and tickets as an Excel file

Description

This plugin allows you to download Trac query output, reports and ticket pages as an Excel spreadsheet file. The plugin creates spreadsheets using openpyxl or xlwt library, both of which are open source licensed.

Key features:

  • In the query and ticket screen, you can download all entries including the change history of tickets.
  • The downloaded data can be further manipulated in Excel spreadsheets.

To use this plugin, visit the query, report or ticket page in your Trac installation. Click the Excel or Excel including history links at the bottom of the pages to initiate an export to an Excel spreadsheet file:

Note: The latter link is unavailable in the report page.

See also: ExportImportXlsPlugin

Bugs/Feature Requests

Existing bugs and feature requests for ExcelDownloadPlugin are here.

If you have any issues, create a new ticket.

defect

6 / 6

enhancement

4 / 6

Download

Download the zipped source from here.

Source

You can check out ExcelDownloadPlugin from here using Subversion, or browse the source with Trac.

Installation

  1. Install the pypi:openpyxl or pypi:xlwt library:
    1. If you want Excel 2007 format (*.xlsx), install pypi:openpyxl<3.0 and pypi:lxml:
      $ easy_install 'openpyxl<3.0' lxml
      # or
      $ pip install 'openpyxl<3.0' lxml
      
    2. If you want Excel 2003 format (*.xls), install pypi:xlwt:
      $ easy_install xlwt
      # or
      $ pip install xlwt
      
      • You could install pypi:xlwt/0.7.5 for Python 2.4 or 2.5.
        $ easy_install xlwt==0.7.5
        # or
        $ pip install xlwt==0.7.5
        
  2. Install the plugin:
    1. For Trac 1.0 and later:
      $ easy_install https://trac-hacks.org/svn/exceldownloadplugin/1.0
      
    2. For Trac 0.12.x:
      $ easy_install https://trac-hacks.org/svn/exceldownloadplugin/0.12
      
  3. Enable the plugin in your trac.ini file:
    [components]
    tracexceldownload.* = enabled
    
  4. Restart your tracd (or web server) if needed.

Recent Changes

17571 by jun66j5 on 2019-11-20 12:41:45
ExcelDownloadPlugin: fix a TypeError raised while upgrade checking on Trac 1.4 (refs #13632)
17570 by jun66j5 on 2019-11-20 12:28:01
ExcelDownloadPlugin: add 1.0 directory for Trac 1.0, 1.2, 1.4 and later (closes #13632)
17569 by jun66j5 on 2019-11-20 12:04:59
ExcelDownloadPlugin: allow unit tests with Trac 0.12.x
(more)

Author/Contributors

Author: jun66j5
Maintainer: Jun Omae
Contributors: OpenGroove,Inc. and tracpath

Last modified 17 hours ago Last modified on Nov 20, 2019, 12:43:24 PM

Attachments (1)

Download all attachments as: .zip