Problem creating Excel sheets

[abhishek jamloki]

I am trying to insert data in an excel sheet using odbc. I use
PreparedStatement for this. My java code does not throw any exceptions
and indicates that the rows have been inserted but when I open the
excel file I do not find any data there. If I open the excel file
using MS Excel and then run my Java code the rows get inserted
properly the way I want them. Can some one please help me out?

 

[Ajay]

 I am trying to insert data in an excel sheet using odbc. I use
PreparedStatement for this. My java code does not throw any exceptions
and indicates that the rows have been inserted but when I open the
excel file I do not find any data there. If I open the excel file
using MS Excel and then run my Java code the rows get inserted
properly the way I want them. Can some one please help me out?

Don't used odbc.
Instead, use POI tools: http://poi.apache.org/

Ajay