wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes Can I write Microsoft Excel file using my Java code? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Can I write Microsoft Excel file using my Java code?" Watch "Can I write Microsoft Excel file using my Java code?" New topic
Author

Can I write Microsoft Excel file using my Java code?

Paul Okeke
Ranch Hand

Joined: May 16, 2009
Posts: 58
I have an Excel Template which is meant to contain some records from the database. Based no the user's request, JSP accesses the database through the Servlet to create an Array of records which will be used to populate the Excel Templet.
Note: This template of Excel already had some data and outlines that can be present in it and also need such information from the database be complete.
I need some help on which API I'll use to get this work done.


OCJP 1.6
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39547
    
  27
The Apache POI library can read and write Excel files, and is widely used for this purpose.


Ping & DNS - updated with new look and Ping home screen widget
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Can I write Microsoft Excel file using my Java code?
 
Similar Threads
Code for transfering data from JSP to Excel Sheet
Deleting columns in excel file to create new Excel file
How to read data from excel file and store it in the database ?
What is the best way to store List<List<String>> in database?
How to Export web page(jsp page) to excel using jsp or servlets