File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Beginning Java and the fly likes Manipulating excel sheets. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "Manipulating excel sheets." Watch "Manipulating excel sheets." New topic

Manipulating excel sheets.

amit smal

Joined: Mar 17, 2005
Posts: 10
hey all,
currently my requirement is manipulating different cells of xls sheet using java program. Is there any class called Workbook() having methods for add, modify , delete?

thanks & regards,
John Dell'Oso
Ranch Hand

Joined: Apr 08, 2004
Posts: 130

Here's a link to a JavaWorld article on Jakarta POI that may be of interest to you.

JavaWorld article - Jakarta POI

Grishma Dube
Ranch Hand

Joined: Jul 01, 2003
Posts: 275
Hi Amit,

You can use difference APIs to read or write to a xls.

I am aware of 2 packages - one is jxl and another is POI. I think POI is provided by Jakarta. You can download the these packages and use it to read or created workbook,etc.


[ March 17, 2005: Message edited by: Grishma Dube ]
amit smal

Joined: Mar 17, 2005
Posts: 10
Thank you John and Grishma...
i m finaly able to do it...

I agree. Here's the link:
subject: Manipulating excel sheets.
jQuery in Action, 3rd edition