java - Do you know of a sophisticated spread sheet like component for Swing

Question

I need to write a data exploration tool that displays large amounts of data in a spreadsheet format.

Salient problem features:

1. Large number of rows -- typically .5 to 1 million
2. 30-50 columns
3. Need to be able to sort on columns
4. Rapidly apply filters -- say hide all rows that have have foobar in them
5. Need to be able to lock rows/cols

Thanks.

Answer 1

The real problem is elucidating the poorly defined row count requirement: typically 0.5 to 1 million. Human beings cannot meaningfully browse hundreds of thousand of rows. Instead, consider some domain-compatible way to select a subset suitable for manipulation according to the other requirements 2-5.

Because its renderers implement the flyweight pattern, JTable is already quite efficient, although optimizations are possible. If the data is hierarchical in nature, org.netbeans.swing.outline.Outline, a JTable subclass examined here, is an appealing alternative.