Excel.WorksheetPositionType enum

Paket:

excel

Die Position eines Arbeitsblatts relativ zu einem anderen Arbeitsblatt oder der gesamten Arbeitsblattauflistung.

Hinweise

[ API-Satz: ExcelApi 1.7 ]

Beispiele

// 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();
});

Felder

after = "After"	[ API-Satz: ExcelApi 1.7 ]
before = "Before"	[ API-Satz: ExcelApi 1.7 ]
beginning = "Beginning"	[ API-Satz: ExcelApi 1.7 ]
end = "End"	[ API-Satz: ExcelApi 1.7 ]
none = "None"	[ API-Satz: ExcelApi 1.7 ]