Converting java file to excel spread sheet -

first of previous help. want following. collect information through small program can capture in java , writes file have done. have information passed preformatted excel spread sheet. in spread sheet reads data written , displays in different tables , graphs. possible automatically code or have write csv file, csv file manually copy excel template? if has come across solution problem appreciate steer in right direction

hey try ths code in servlet or in jsp. convert simple excel sheet on can further operations..

    response.setcontenttype("application/vnd.ms-excel");     printwriter out = response.getwriter();     try {             out.println("\tid \tname");             out.println("\t1\tabc");             out.println("\t2\txyz");             out.println("\t3\tpqr");     } {         out.close();     } 

here ..

response.setcontenttype("application/vnd.ms-excel"); 

specify excel sheet generated.. "\t" separates new cell in excel sheet.

on requirement basis can change code database or any...