[[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. * 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: [[Image(format-excel.png,border=2)]] '''Note:''' The latter link is unavailable in the report page. See also: ExportImportXlsPlugin == 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] which is optional but reduces memory usage): {{{#!sh $ pip install openpyxl lxml }}} b. If you want Excel 2003 format (*.xls), install pypi:xlwt: {{{#!sh $ pip install xlwt }}} - You could install pypi:xlwt/0.7.5 for Python 2.4 or 2.5. {{{#!sh $ pip install xlwt==0.7.5 }}} 1. Install the plugin: a. For Trac 1.0 and later: {{{#!sh $ pip install svn+https://trac-hacks.org/svn/exceldownloadplugin/1.0 }}} b. For Trac 0.12.x: {{{#!sh $ pip install svn+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:''' [https://www.opengroove.com/ OpenGroove,Inc.] and [https://tracpath.com/ tracpath]