你可以使用触控支持来展开或者收起分组。
点击表头的分组按钮来展开或者收起分组。
示例代码
以下代码创建了行分组和列分组。
JavaScript | Copy Code |
activeSheet.suspendPaint();activeSheet.setRowCount(34);activeSheet.setValue(0,0,"Western");activeSheet.setValue(0,1,"Western");activeSheet.setValue(0,2,"Western");activeSheet.setValue(1,0,"A");activeSheet.setValue(1,1,"B");activeSheet.setValue(1,2,"C");activeSheet.setValue(2,0,"A");activeSheet.setValue(2,1,"B");activeSheet.setValue(2,2,"C");activeSheet.rowOutlines.group(0,2);activeSheet.columnOutlines.group(0,1);activeSheet.resumePaint(); |
|