Automation of Java-based Excel Report Generation using Aspose API

[simikadampatta]

Hello,

Currently we have configured an Excel report that is generated whenever user clicks a button.

The report is generated by executing a JAR using JAVA Aspose.Cells API.

Can we automate this report generation?

How can we automatically trigger the JAR at the end of every month so that report is generated automatically, instead of a user clicking the button?

[hsoegaard]

If you create a macro in HOPEX that calls yout java, you can then create a Trigger in HOPEX Administrator. This Trigger can then be scheduled to run every month.

Your java function probably has to be saving the report in a specific place or just update the report if it is one you access inside HOPEX.