[[PageOutline(2-5,Contents,pullout)]]

= 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 [PyPI:openpyxl] or [PyPI: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.

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:

[[Image(format-excel.png,border=2)]]

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

See also: ExportImportXlsPlugin, ExcelReportPlugin

== Bugs/Feature Requests

Existing bugs and feature requests for ExcelDownloadPlugin are 
[report:9?COMPONENT=ExcelDownloadPlugin here].

If you have any issues, create a 
[/newticket?component=ExcelDownloadPlugin new ticket].

[[TicketQuery(component=ExcelDownloadPlugin,group=type,format=progress)]]

== Download

Download the zipped source from [export:exceldownloadplugin here].

== Source

You can check out ExcelDownloadPlugin from [/svn/exceldownloadplugin here] using Subversion, or [source:exceldownloadplugin browse the source] with Trac.

== Installation

 1. Install the pypi:openpyxl or pypi:xlwt library:
    a. If you want Excel 2007 format (*.xlsx), install pypi:openpyxl and pypi:lxml:
 {{{#!sh
$ easy_install openpyxl lxml
# or
$ pip install openpyxl lxml
}}}
    b. If you want Excel 2003 format (*.xls), install pypi:xlwt:
 {{{#!sh
$ easy_install xlwt
# or
$ pip install xlwt
}}}
       - You could install pypi:xlwt/0.7.5 for Python 2.4 or 2.5.
 {{{#!sh
$ easy_install xlwt==0.7.5
# or
$ pip install xlwt==0.7.5
}}}
 1. Install the plugin:
 {{{#!sh
$ easy_install https://trac-hacks.org/svn/exceldownloadplugin/0.12
}}}
 1. Enable the plugin in your `trac.ini` file:
{{{#!ini
[components]
tracexceldownload.* = enabled
}}}
 1. Restart your tracd (or web server) if needed.

== Recent Changes

[[ChangeLog(exceldownloadplugin, 3)]]

== Author/Contributors

'''Author:''' [wiki:jun66j5] [[BR]]
'''Maintainer:''' [[Maintainer]] [[BR]]
'''Contributors:''' [http://www.opengroove.com/ OpenGroove,Inc.] and [http://tracpath.com/ tracpath]