Hi,
I have a requirement in Aurena to add an action which will output an Excel file with sheets.
Action should be added to the parent and when clicked all the child elements should be added as sheets of that excel file and excel file should be downloaded.
Any suggestions? 🤔
Thanks
Regards,
Tharindu
Exporting data to Excel file with separate sheets for each table in Aurena
Userlevel 3
+7
This topic has been closed for comments
Userlevel 7
+30
You would probably need to get your hands dirty with some Java coding to do that.
You will need to do a lot of database queries in Java, plus create an Excel file also using Java code (I am sure there are libraries for it).
It’s probably hard work, but it should be doable. I mean our reporting functionality does something similar when it creates Excel file. So there should exist code to look at (no, I don’t know where :) )
Good luck!
Userlevel 3
+7
Thank you 
Regards,
Tharindu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.