[[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 is dependent on xlwt, which is a Python library to create spreadsheet files compatible with MS Excel 97/2000/XP/2003 XLS files, on any platform with Python 2.6, 2.6, 3.3+.

Key features:
 * In the query and ticket screen, you can download all entries including the change history of tickets.

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:xlwt library:
 {{{#!sh
easy_install xlwt
}}}
    Or:
 {{{#!sh
pip install xlwt
}}}
    - You could install pypi:xlwt/0.7.5 if you are using Python 2.4 or 2.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.

== Example

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.

== 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]