你知道像Swing组件那样复杂的电子表格吗？ [英] 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.

突出问题功能：

1. 大量行 - 通常为.5到100万


2. 30-50列


3. 需要能够对列进行排序


4. 快速应用过滤器 - 说隐藏所有包含foobar的行


5. 需要能够锁定行/列

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

谢谢。

推荐答案

真正的问题是阐明定义不明确的行数要求：通常为0.5到100万。人类无法有意义地浏览数十万行。相反，请考虑一些与域兼容的方法来根据其他要求选择适合于操作的子集2-5。

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.

因为它的渲染器实现了flyweight模式， JTable 已经非常高效，但< a href =http://java.sun.com/products/jfc/tsc/articles/ChristmasTree/ =nofollow noreferrer>优化是可能的。如果数据本质上是分层的，则 org.netbeans.swing.outline.Outline ，检查 JTable 子类这里是一个很有吸引力的选择。

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.

这篇关于你知道像Swing组件那样复杂的电子表格吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！