Excel.WorksheetPositionType enum

包:

excel

工作表相对于另一个工作表或整个工作表集合的位置。

注解

[ API 集：ExcelApi 1.7 ]

示例

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/50-workbook/workbook-insert-external-worksheets.yaml

await Excel.run(async (context) => {
    // Retrieve the source workbook.
    const workbook = context.workbook;
    
    // Set up the insert options.
    const options = {
        sheetNamesToInsert: [], // Insert all the worksheets from the source workbook.
        positionType: Excel.WorksheetPositionType.after, // Insert after the `relativeTo` sheet.
        relativeTo: "Sheet1" // The sheet relative to which the other worksheets will be inserted. Used with `positionType`.
    };
    
    // Insert the new worksheets.
    workbook.insertWorksheetsFromBase64(externalWorkbook, options);
    await context.sync();
});

字段

after = "After"	[ API 集：ExcelApi 1.7 ]
before = "Before"	[ API 集：ExcelApi 1.7 ]
beginning = "Beginning"	[ API 集：ExcelApi 1.7 ]
end = "End"	[ API 集：ExcelApi 1.7 ]
none = "None"	[ API 集：ExcelApi 1.7 ]