Excel.RangeCopyType enum

Package:

excel

Remarks

[ API set: ExcelApi 1.9 ]

Examples

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

Fields

all = "All"	[ API set: ExcelApi 1.9 ]
columnWidths = "ColumnWidths"	[ API set: ExcelApi BETA (PREVIEW ONLY) ]
formats = "Formats"	[ API set: ExcelApi 1.9 ]
formulas = "Formulas"	[ API set: ExcelApi 1.9 ]
link = "Link"	[ API set: ExcelApiOnline 1.1 ]
values = "Values"	[ API set: ExcelApi 1.9 ]