Export Jenkins reports to Excel

Question

I am new to Jenkins. We have jenkins kicking off several builds every night and I want to pull the failures out from all builds and put them into excel (or google dox version of excel). Is there any smart way to do this? Thanks

Answer 1

Now that Jenkins integrates Groovy for Pipeline builds, or just plain Groovy scripts, it is straightforward to write some Groovy code that uses the Apache POI libraries to create a genuine Excel spreadsheet with colors, fonts, highlights or whatever you need.

Answer 2

Create a script and use it as a Post Steps build phase with an option Run regardless of build result checked. The script, which can be anything, can push data after every build to CSV file, and if you use PowerShell - to the Excel file as well. Damn, if you use Google Docs SDK you can easily add data to GDoc Spreadsheet or do something else. No limits here.