This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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

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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Manipulating excel sheets.
It's not a secret anymore!