Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I customize the spreadsheet format when exporting a list of items to Excel?

Ismael Masso Arroyo
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 7, 2014

I'm trying to generate an Excel report of JIRA items filtered and extracted from Issues Filter area. Fields and Excel file are generated ok but the format is not as I expected. 

 - Logged work time appears in Seconds which is unmanageable.

 - Columns and Rows format are not very presentable.

How can it be customized?

Thanks

3 answers

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 8, 2014

Not available for Cloud

0 votes
Midori
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 8, 2014

Use the Better Excel Plugin.

You can customize the Excel reportsby creating actual Excel files in Excel. No need to write a single line code, unless you want to run Groovy during the export, which opens another horizon for possibilities.

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 7, 2014

Code.

You'll need to hack the code that generates the XML output to include your formatting and calculation from seconds to whatever-you-want.

Oops, sorry, only just noticed the "cloud" tag.  That also means you can't make the code changes you need to make.  You can only make code changes on Server version.

Ismael Masso Arroyo
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 7, 2014

I see... Thanks for your reply Nic!

Suggest an answer

Log in or Sign up to answer