excel.rangecopytype.yml

### YamlMime:TSEnum
name: Excel.RangeCopyType
uid: 'excel!Excel.RangeCopyType:enum'
package: excel!
fullName: Excel.RangeCopyType
summary: ''
remarks: >-
  \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]


  #### Examples


  ```TypeScript

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

  ```
isPreview: false
isDeprecated: false
fields:
  - name: all
    uid: 'excel!Excel.RangeCopyType.all:member'
    package: excel!
    summary: '* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"All"'
  - name: columnWidths
    uid: 'excel!Excel.RangeCopyType.columnWidths:member'
    package: excel!
    summary: >-
      * \[ [API set: ExcelApi BETA (PREVIEW ONLY)](/javascript/api/requirement-sets/excel/excel-api-requirement-sets)
      \]
    value: '"ColumnWidths"'
  - name: formats
    uid: 'excel!Excel.RangeCopyType.formats:member'
    package: excel!
    summary: '* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"Formats"'
  - name: formulas
    uid: 'excel!Excel.RangeCopyType.formulas:member'
    package: excel!
    summary: '* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"Formulas"'
  - name: link
    uid: 'excel!Excel.RangeCopyType.link:member'
    package: excel!
    summary: '* \[ [API set: ExcelApiOnline 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"Link"'
  - name: values
    uid: 'excel!Excel.RangeCopyType.values:member'
    package: excel!
    summary: '* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"Values"'