How to develop pivot table in java?

[rai]

Hi,
I am developing a tool that is to replace a rather large Excel Workbook and I am trying to minimise the development effort. In order to do so - I am looking for Java Components that do similar things to what excel does.

The primary functionality that I am looking to implement is the following:

a) A table that can be easily exported to Excel
b) Provides the Pivot Table functionality (as in Excel)
c) Provides the general table functionality like - filtering, sorting, copy & paste
d) Is something that has a real professional look and the look & feel can be customised.

Further info: I am developing in Java and using NetBeans as the IDE.

Any ideas?

[DarrylBurke]

I've never used OpenOffice, but I believe it has a Java API.

db