1.I have a complex task in my hand.
First i need to run a java program to generate a list of columns.
2.The data produced from the JAVA needs to be put in an excel sheet, average of a column needs to be calculated and a histogram needs to be produced.
3.This excel sheet needs to be attached and sent through every day at a certain time.
So i want to integrate everything in UNIX and set a crontab.
Could you please help me to figure out an action plan.I am confused how to take the o/p from the java console, prepare the excel and again attach this to unix shell script to send as mail.Shell scripting is not a problem.
It would be of great help if you could give me a rough overview on how to proceed.