CODEWITHSUNDEEP
javaswingjtablespreadsheet
user975917
user975917

Reputation: 293

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

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.

Upvotes: 1

Views: 486

Answers (1)

trashgod
trashgod

Reputation: 205835

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.

Upvotes: 4

Related Questions