how to automate excel report and send from un

Eclipse Eclipse ecl-sc1
February 9, 2010 at 16:03:10
Specs: Linux/Ubuntu
Hi Friends,

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.

See More: how to automate excel report and send from un

February 10, 2010 at 05:42:20
A you need to create a Java program, you need
B some kind of conversion from a given file to an Excel format
C you need to use a mailing program
D create a script that will to actually mail it
E and then be put into crontab

Well, step by step ...

A create a thread on this site
B idem
C in *nix, type : man mail
D no problem you mention
E in *nix, type : man crontab

Report •

February 10, 2010 at 11:34:14
Sure tvc .Thanks for decomposing the problem into meaning ful chunks.
I will comeback with the basic Java Program, What i have, to start the thread.
Can you please elaborate on this thing called 'idem' or post some link where i can find more on this.
I want to create a small histogram in the excel sheet using the data as well.I have heard about POI not pretty sure though.

Report •

September 24, 2010 at 11:32:10
please post the kind of data the java program will process and whether the data to be processed is user input or read from any existing source(aka database)

Report •
Related Solutions

Ask Question