I want to store the results generated out of SQL query into excel file ...
how do I go about doing it?

Read up on JDBC, first (the Sun tutorials are enough).

Then download, read the documentation for, and experiment with, either POI or JExcel.

Then, combine the lessons learned from the two above points.

or write your own code to write out SLK...
Not the nicest code to look at, but you loose dependencies on another few external libraries which may be worth it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.