Excel.SortOn enum

包:

excel

表示用作排序条件的单元格部分。

注解

[ API 集：ExcelApi 1.2 ]

示例

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/30-events/event-column-and-row-sort.yaml

async function sortTopToBottom(criteria: string) {
    await Excel.run(async (context) => {
        const sheet = context.workbook.worksheets.getActiveWorksheet();
        const range = sheet.getRange("A1:E5");

        // Find the column header that provides the sort criteria.
        const header = range.find(criteria, {});
        header.load("columnIndex");
        await context.sync();

        range.sort.apply(
            [
                {
                    key: header.columnIndex,
                    sortOn: Excel.SortOn.value
                }
            ],
            false /*matchCase*/,
            true /*hasHeaders*/,
            Excel.SortOrientation.rows
        );
        await context.sync();
    });
}

字段

cellColor = "CellColor"	[ API 集：ExcelApi 1.2 ]
fontColor = "FontColor"	[ API 集：ExcelApi 1.2 ]
icon = "Icon"	[ API 集：ExcelApi 1.2 ]
value = "Value"	[ API 集：ExcelApi 1.2 ]