[[PageOutline(2-5,Contents,pullout)]] = 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 [report:9?COMPONENT=ExcelXlstViewerPlugin here]. If you have any issues, create a [/newticket?component=ExcelXlstViewerPlugin new ticket]. [[TicketQuery(component=ExcelXlstViewerPlugin&group=type,format=progress)]] == Download Download the zipped source from [export:excelxlstviewerplugin here]. == Source You can check out ExcelXlstViewerPlugin from [/svn/excelxlstviewerplugin here] using Subversion, or [source:excelxlstviewerplugin browse the source] with Trac. == Installation First install the openpyxl library: `easy_install openpyxl`. General instructions on installing Trac plugins can be found on the [TracPlugins#InstallingaTracplugin 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: {{{#!sh 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 openpyxl is installed correctly by running python and entering "import openpyxl". You should see no error. Also ensure that ''mime_map'' is set properly as documented above. == Recent Changes [[ChangeLog(excelxlstviewerplugin, 3)]] == Author/Contributors '''Author:''' [wiki:danrolls] [[BR]] '''Maintainer:''' [[Maintainer]] [[BR]] '''Contributors:'''