设置排序升序属性

Sort.IsAscending(属性)

说明

可读写

设置排序升序或者降序

返回值

Boolean

浏览器环境示例

// 获取IsAscending属性
async function example() {
    await instance.ready();
    const app = instance.Application;
    const sorts = await app.Sheets(1).Views(1).Sorts;
    const isAscending = sorts(1).IsAscending;
}

// 设置IsAscending属性
async function example() {
    await instance.ready();
    const app = instance.Application;
    app.Sheets(1).Views(1).Sorts(1).IsAscending = false;
}

脚本编辑器 示例

function main() {
    const sorts = Application.Sheets(1).Views(1).Sorts;
    const isAscending = sorts(1).IsAscending;
    isAscending = false;
}
main()