Excel.RangeCopyType enum

Paket:

excel

Hinweise

[ API-Satz: ExcelApi 1.9 ]

Beispiele

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

Felder

all = "All"	[ API-Satz: ExcelApi 1.9 ]
columnWidths = "ColumnWidths"	[ API-Satz: ExcelApi BETA (NUR VORSCHAU) ]
formats = "Formats"	[ API-Satz: ExcelApi 1.9 ]
formulas = "Formulas"	[ API-Satz: ExcelApi 1.9 ]
link = "Link"	[ API-Satz: ExcelApiOnline 1.1 ]
values = "Values"	[ API-Satz: ExcelApi 1.9 ]