Project

General

Profile

XLS export plugin

Added by Vitaly Klimov about 14 years ago

Up to date plugin page

http://www.redmine.org/plugins/redmine_xls_export

XLS export plugin

With the help of this plugin you can export issues list with all information to XLS file. Also it is possible to export issues with attachments as a ZIP archive.

Requirements

Plugin requires Redmine version 1.3.0 or higher.

Plugin relies on spreadsheet gem for XLS based operations. Please install this gem before running plugin. Also if you want to use attachments export you should install rubyzip gem.

Features

  • Export active or all columns
  • Export issue descriptions
  • Export journal entries - both inline or as separate file per each issue
  • Export relations information
  • Export spent time data
  • List attachments information
  • Export attachments
  • Export watchers
  • Split information by sheets based on grouping criteria
  • Correct formatting and width of worksheet cells

Details

Plugin adds following links with 'XLS export:' prefix at the bottom of the page under 'Also available in' bar:

  • Quick
    One click export to XLS using default export settings from plugin configuration screen
  • Detailed
    Brings up dialog where user can choose export options before export

Installation and Setup

  1. Install spreadsheet gem ('gem install spreadsheet')
  2. Install rubyzip gem if you want to use export attachments feature
  3. Install plugin Plugin views with revisions if you do not have it installed
  4. Follow the Redmine plugin installation steps at: http://www.redmine.org/wiki/redmine/Plugins
  5. Run rake task
    rake redmine:plugins:process_version_change RAILS_ENV=production
  6. Login and configure the plugin (Administration > Plugins > Configure)

Replies (276)

RE: XLS export plugin - Added by Tatsuya Saito over 7 years ago

Dario Laera wrote:

Hi Vitaly,

I'm an happy user of your plugin, but I was wondering if it's possible to schedule an automatic export of an xls. In other words, I need to generate weekly an xls with the issues of some projects. Do you think it's feaseble within redmine using your plugin?

I'm not sure how to do it with Redmine XLS Export.
But another plugin, Redmine XLSX format issue exporter , has REST API.
You can export issues list which is XLSX format using GET request like following url:

http://127.0.0.1:3000/projects/test/issues.xlsx?query_id=1

See [Solved] Export by command line

So I think you can export issues list using other scheduler like Jenkins, cron, etc.

I hope this will help.

(276-276/276)