Is it possible to send an excel file with all the custom fields data as an email to a user.
if a jira ticket is created an email should be sent to me with an attachment of an excel sheet with all custom field name and its data.
If you ok with csv instead of Excel then yes possible to do that, write a scripted post function on create. You will also find examples to send mail here http://library.adaptavist.com/
csv is very easy to generate but if you really want to generate Excel (I am sure you have good reasons for that) then I highly recommend using Better Excel plugin which I have used in the past, it has REST end point if I remember correctly to generate the file and it integrates well with ScriptRunner. You will find examples in their documentation as well.
I hope it helps.
It is very simple to generate a simple csv. In Groovy you have methods to create a file on disk and write on it.
File file = new File(/tmp/tmp.csv)
In this case it is just one line but you can build your csv with multiple lines as well.
As Ravi Mentioned, you can use a dedicated solution to automatically generate and email (or attach, save to local filesystem) a native Excel file from Jira.
Watch this short tutorial that shows how you can make it work: https://www.youtube.com/watch?v=vdDAoCTdJNc&t=32s
(Please note that Better Excel Automation for Jira is free, while Better Excel Exporter is a paid and supported app and I'm part of the team developing both apps.)
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event