Excel.WorksheetPositionType enum

Paquete:

excel

Posición de una hoja de cálculo relativa a otra hoja de cálculo o a toda la colección de hojas de cálculo.

Comentarios

[ Conjunto de API: ExcelApi 1.7 ]

Ejemplos

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

Campos

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