wiki:ExcelXlstViewerPlugin

Version 6 (modified by figaro, 8 years ago) (diff)

Cosmetic changes

Viewer for Microsoft Excel XLST files

Description

This hack allows uploaded Excel files on the Wiki or in tickets to be viewed in the web browser as a HTML table. It allows everybody to easily view the files without downloading and saving the Excel files and without even requiring Microsoft Excel. It is derived from the ExcelViewerPlugin hack, but depends upon the openpyxl library.

Bugs/Feature Requests

Existing bugs and feature requests for ExcelXlstViewerPlugin are here.

If you have any issues, create a new ticket.

defect

2 / 2

task

1 / 1

Download

Download the zipped source from here.

Source

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

Installation

First install the openpyxl library: easy_install xlrd.

General instructions on installing Trac plugins can be found on the TracPlugins page.

After installing add the following to the mime_map property in your trac.ini file to tell Trac which types of file work with the plugin:

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet:xlsx,application/vnd.ms-excel.sheet.macroEnabled.12:xlsm

Example

Upload an Excel document from an up-to-date version of Microsoft Excel as an attachment. As long as it is in the new xlst format the plugin will work. For older files use ExcelViewerPlugin. If it doesn't work confirm xlrd is installed correctly by running python and entering "import xlrd". You should see no error. Also ensure that mime_map is set properly as documented above.

Recent Changes

16799 by rjollos on 2017-09-08 20:35:40
TracExcelXlstViewer 1.0dev: Make compatible with Trac 1.0+ and newer openpyxl

Be sure to uninstall the old plugin before installing this
version, as the entry point has been changed.

Fixes #13269.

16798 by rjollos on 2017-09-08 19:01:17
TracExcelXLSTViewer 0.9.3: Fix mixed tabs and spaces

Refs #13269.

15584 by rjollos on 2016-06-07 22:27:55
Remove intermediate directory
(more)

Author/Contributors

Author: danrolls
Maintainer: Daniel Rolls
Contributors: