Processing method for presenting data index hierarchies and classifications in spreadsheet

The invention discloses a processing method for presenting data index hierarchies and classifications in a spreadsheet, and the method comprises the steps: building an index index structure S, presenting indexes and hierarchies, index classification description and hierarchies, application scenes of index and index classification description and other implicit attributes in a spreadsheet mode according to the personalized selection of a user, so that index expression is simpler, readability is higher, accurate expression of two-dimensional table data can be achieved, and a presented table is easier to understand. And on the basis, indexes and index classification description can be flexibly and variously combined and displayed, so that the displayed result is more diversified, flexible andpersonalized. 本发明公开了一种在电子表格中呈现数据指标层级与分类的处理方法，通过构建指标索引结构S，依据用户的个性化选择，以电子表格形式呈现指标及层级、指标分类描述及层级、指标与指标分类描述的应用场景以及其它隐含属性，从而使指标表述更简洁、可读性更强，能够实现对二维表格数据的准确表达，呈现的表格更易于理解；并基于此，还能够对指标和指标分类描述灵活多样组合展示，使呈现的结果更加多样化、灵活化、个性化。