Java program to open excel file every day and print it

[donnerj]

Is it possible to create a simple java program that
will open an excel file every day at a certain time and
send the output to a printer ? If this is possible how
would I go about doing this ?

 

[DJSmith]

You need to use a Java COM Bridge to be able to use MS Office programs from a java environment. I have found that JACOB (JAva-COm Bridge) is quite easy to use (

http://danadler.com/jacob/).

There are plenty of examples around on how to use JACOB and running the process everyday should just be a matter of setting it up in your schedule.

 

[byam]

If you want your program to be OS independent, an alternative pure JAVA solution is to use apache POI-HSSF API.

http://jakarta.apache.org/poi/hssf/index.html