Excel.RangeCopyType enum

Paquet:

excel

Remarques

[ Ensemble d’API : ExcelApi 1.9 ]

Exemples

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/42-range/range-copyfrom.yaml

await Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getItem("Sample");
    // Place a label in front of the copied data.
    sheet.getRange("F2").values = [["Copied Formula"]];

    // Copy a range preserving the formulas.
    // Note: non-formula values are copied over as is.
    sheet.getRange("G2").copyFrom("A1:E1", Excel.RangeCopyType.formulas);
    await context.sync();
});

Champs

all = "All"	[ Ensemble d’API : ExcelApi 1.9 ]
columnWidths = "ColumnWidths"	[ Ensemble d’API : ExcelApi BETA (PRÉVERSION UNIQUEMENT) ]
formats = "Formats"	[ Ensemble d’API : ExcelApi 1.9 ]
formulas = "Formulas"	[ Ensemble d’API : ExcelApi 1.9 ]
link = "Link"	[ Ensemble d’API : ExcelApiOnline 1.1 ]
values = "Values"	[ Ensemble d’API : ExcelApi 1.9 ]