File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes dispaly records in format of excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "dispaly records in format of excel" Watch "dispaly records in format of excel" New topic

dispaly records in format of excel

arvind dhar

Joined: Jul 09, 2008
Posts: 2
Hello Ranchers,
i am in very confusion i am having one table in database and i want to fetch some records from database through the programming java (j2ee) i am not able to find out . can any one give me one example for it and any sites where which is useful for this
i am very thankful
Jetendra Ivaturi
Ranch Hand

Joined: Feb 08, 2007
Posts: 159
You just want to get the records from database or printthem in excel format...

SCJP 1.4 & 1.5, SCWCD 1.5. Learn and Let Learn.
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1323

FAQs Entries.

Accessing File Formats
Jsp And Excel

hope this helps.

[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
Rodrigo Tomita
Ranch Hand

Joined: Apr 28, 2008
Posts: 70

I think the simplest way is to fetch the data using JDBC (you can look at PreparedStatement class, for instance) and to use the JavaRanch FAQ about JSP and Excel (as Muhammad pointed out) to send that to the user browser.
Amit Ghorpade

Joined: Jun 06, 2007
Posts: 2851

Hi aarvind or gan_arvind
unable to determine your current display name as in the post it is showing aarvind and in the topic starter its gan_arvind.

Anyways both are not valid acording to Javarnch Naming policy.
Ben has already asked you two times to adhere to the policy.
Please take some time to read the above link. And change your display name.
[ July 16, 2008: Message edited by: Amit Ghorpade ]

|Asking Good Questions|
I agree. Here's the link:
subject: dispaly records in format of excel
It's not a secret anymore!