Page 1 of 1

generate daily excel report

Posted: Mon Sep 23, 2019 9:02 am
by manalidhuri
I have exported table into excel sheet as shown in screenshot, and I have to generate the same daily report and mail it to the user ,but it has to be done without user action(i.e It does not include any user action )
so is it possible through trigger?
or do you have any solution regarding this?

Thanks

Re: generate daily excel report

Posted: Tue Sep 24, 2019 4:13 pm
by amosbatto
Where are you getting the content in your Excel report? A database query? A file uploaded by users?

I wrote up an example, that should help you get started:
https://www.pmusers.com/index.php/Creat ... d_email_it

Re: generate daily excel report

Posted: Wed Sep 25, 2019 4:40 am
by amithatle123
Sorry for inconvenience,

There is no column " APPLICATION" number in table, I have attached the PM table which we want. All data insert through Java application(JAR).

Re: generate daily excel report

Posted: Wed Sep 25, 2019 5:31 pm
by amosbatto
You can adjust the code to match your table. I gave you a generic example that you should be able to adapt.

Re: generate daily excel report

Posted: Sun Sep 29, 2019 11:54 pm
by amithatle123
Thank You :)