Page History

You can sort data in the widget and specify a column or row index to sort on as well as the sort criteria. You can also specify multiple sort keys (sort by a specified column or row first, then another column or row, and so on).

Use the sortRange method to sort data. Use the sortInfo object in the sortRange method to specify sort keys and ascending or descending order.

Using Code

Select one of the buttons to sort the first column.你可以在控件中给数据排序，并且制定一个排序规则，比如指定行或者指定列来排序等。

你也可以指定多个排序关键字（先按照某一行或者一列排序，再按照某一行或者一列排序，依此类推）。

使用 sortRange 方法来对数据进行排序。使用 sortRange 中的 sortInfo 对象来设置排序的关键字，升序还是降序等。

示例代码

点击按钮来按照第一列排序

JavaScript

Copy Code

$("#button2").click(function(){
    //Sort Column1 by descending at every button click.
     activeSheet.sortRange(-1, 0, -1, 1, true, [
       {index:0, ascending:false}
     ]);
});
//Add button controls to page在界面上添加两个按钮
<input type="button" id="button1" value="button1"/>
<input type="button" id="button2" value="button2"/>

Using Code

...

示例代码

点击按钮来按照 sortInfo 设置的排序标准来排序。

JavaScript

Copy Code

activeSheet.setRowCount(6);
activeSheet.setValue(0, 0, 10);
activeSheet.setValue(1, 0, 100);
activeSheet.setValue(2, 0, 100);
activeSheet.setValue(3, 0, 10);
activeSheet.setValue(4, 0, 5);
activeSheet.setValue(5, 0, 10);
activeSheet.setValue(0, 1, 10);
activeSheet.setValue(1, 1, 40);
activeSheet.setValue(2, 1, 10);
activeSheet.setValue(3, 1, 20);
activeSheet.setValue(4, 1, 10);
activeSheet.setValue(5, 1, 40);

    $("#button1").click(function(){
        //Create a SortInfo object where 1st key is column 1 and the 2nd key is column 2.创建 SortInfo 对象，主要关键字是 column1，次要关键字是 column2。
        var sortInfo = [
            {index:0, ascending:true},
            {index:1, ascending:true}];
        ///Execute sorting which targets all rows based on the created sorting conditions.执行该排序
        activeSheet.sortRange(0, -1, 6, -1, true, sortInfo);
    });

//Add button control to page在页面中添加按钮
<input type="button" id="button1" value="button1"/>

...

Page tree

Versions Compared

Old Version 1

New Version 2

Key

Using Code

示例代码

Using Code

示例代码