Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Android Security Essentials Live Lessons this week in the Android 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: 41132
    
  45
The Apache POI library can read and write Excel files, and is widely used for this purpose.


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can I write Microsoft Excel file using my Java code?
 
Similar Threads
Code for transfering data from JSP to Excel Sheet
What is the best way to store List<List<String>> in database?
Deleting columns in excel file to create new Excel file
How to Export web page(jsp page) to excel using jsp or servlets
How to read data from excel file and store it in the database ?