POI HSSF

It and JExcel, to my knowledge, are the best Java open source projects for Excel manipulation. Other options are OpenOffice's API and/or the JDBC-ODBC bridge. Personally, I have used POI and find it easy to understand. If you are not doing anything exceptionally fancy, it should serve your needs. Best of luck.

- Saish

Saisha at 2007-7-9 22:56:46 >

> >View of what?

>

> Apologies for the confusion, basicalyy I am trying to

> find out what is thought of the tool in general i.e.

> good/bad. Has anyone used this tool to generate

> formulas?

I haven't, and I guess I'm like most. It's easier to use what Sun provides. In principle though it's good for Java to broaden the spectrum. Eclipse is a good example I think and Jakarta too.

With the open sourcing of Java more people will reach outside what Sun provides for high quality software, so why not just go ahead and use it and report back your findings -:)

Djaunla at 2007-7-9 22:56:46 >

For what it's worth, I use both JExcel and HSSF and have a preference for JExcel. It is easier to handle images using JExcel, it exposes a greater variety of cell types and makes it easier to access the formatting objects applied to them. Having said that, JExcel was written mainly by a single developer who also shoulders the burden of maintaining and developing the API; therefore, whilst it is often updated it is arguable that HSSF is the better maintained and more regularly enhanced of the two.

Tillermana at 2007-7-9 22:56:46 >