excel.interfaces.tableloadoptions.yml

### YamlMime:TSType
name: Excel.Interfaces.TableLoadOptions
uid: 'excel!Excel.Interfaces.TableLoadOptions:interface'
package: excel!
fullName: Excel.Interfaces.TableLoadOptions
summary: >-
  Represents an Excel table. To learn more about the table object model, read [Work with tables using the Excel
  JavaScript API](https://learn.microsoft.com/office/dev/add-ins/excel/excel-add-ins-tables)<!-- -->.
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: $all
    uid: 'excel!Excel.Interfaces.TableLoadOptions#$all:member'
    package: excel!
    fullName: $all
    summary: >-
      Specifying `$all` for the LoadOptions loads all the scalar properties (e.g.: `Range.address`<!-- -->) but not the
      navigational properties (e.g.: `Range.format.fill.color`<!-- -->).
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: '$all?: boolean;'
      return:
        type: boolean
  - name: autoFilter
    uid: 'excel!Excel.Interfaces.TableLoadOptions#autoFilter:member'
    package: excel!
    fullName: autoFilter
    summary: Represents the `AutoFilter` object of the table.
    remarks: '\[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'autoFilter?: Excel.Interfaces.AutoFilterLoadOptions;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.AutoFilterLoadOptions:interface" />'
  - name: columns
    uid: 'excel!Excel.Interfaces.TableLoadOptions#columns:member'
    package: excel!
    fullName: columns
    summary: Represents a collection of all the columns in the table.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'columns?: Excel.Interfaces.TableColumnCollectionLoadOptions;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.TableColumnCollectionLoadOptions:interface" />'
  - name: highlightFirstColumn
    uid: 'excel!Excel.Interfaces.TableLoadOptions#highlightFirstColumn:member'
    package: excel!
    fullName: highlightFirstColumn
    summary: Specifies if the first column contains special formatting.
    remarks: '\[ [API set: ExcelApi 1.3](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'highlightFirstColumn?: boolean;'
      return:
        type: boolean
  - name: highlightLastColumn
    uid: 'excel!Excel.Interfaces.TableLoadOptions#highlightLastColumn:member'
    package: excel!
    fullName: highlightLastColumn
    summary: Specifies if the last column contains special formatting.
    remarks: '\[ [API set: ExcelApi 1.3](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'highlightLastColumn?: boolean;'
      return:
        type: boolean
  - name: id
    uid: 'excel!Excel.Interfaces.TableLoadOptions#id:member'
    package: excel!
    fullName: id
    summary: >-
      Returns a value that uniquely identifies the table in a given workbook. The value of the identifier remains the
      same even when the table is renamed.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'id?: boolean;'
      return:
        type: boolean
  - name: legacyId
    uid: 'excel!Excel.Interfaces.TableLoadOptions#legacyId:member'
    package: excel!
    fullName: legacyId
    summary: Returns a numeric ID.
    remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'legacyId?: boolean;'
      return:
        type: boolean
  - name: name
    uid: 'excel!Excel.Interfaces.TableLoadOptions#name:member'
    package: excel!
    fullName: name
    summary: >-
      Name of the table.


      The set name of the table must follow the guidelines specified in the [Rename an Excel
      table](https://support.microsoft.com/office/fbf49a4f-82a3-43eb-8ba2-44d21233b114) article.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'name?: boolean;'
      return:
        type: boolean
  - name: rows
    uid: 'excel!Excel.Interfaces.TableLoadOptions#rows:member'
    package: excel!
    fullName: rows
    summary: Represents a collection of all the rows in the table.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'rows?: Excel.Interfaces.TableRowCollectionLoadOptions;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.TableRowCollectionLoadOptions:interface" />'
  - name: showBandedColumns
    uid: 'excel!Excel.Interfaces.TableLoadOptions#showBandedColumns:member'
    package: excel!
    fullName: showBandedColumns
    summary: >-
      Specifies if the columns show banded formatting in which odd columns are highlighted differently from even ones,
      to make reading the table easier.
    remarks: '\[ [API set: ExcelApi 1.3](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showBandedColumns?: boolean;'
      return:
        type: boolean
  - name: showBandedRows
    uid: 'excel!Excel.Interfaces.TableLoadOptions#showBandedRows:member'
    package: excel!
    fullName: showBandedRows
    summary: >-
      Specifies if the rows show banded formatting in which odd rows are highlighted differently from even ones, to make
      reading the table easier.
    remarks: '\[ [API set: ExcelApi 1.3](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showBandedRows?: boolean;'
      return:
        type: boolean
  - name: showFilterButton
    uid: 'excel!Excel.Interfaces.TableLoadOptions#showFilterButton:member'
    package: excel!
    fullName: showFilterButton
    summary: >-
      Specifies if the filter buttons are visible at the top of each column header. Setting this is only allowed if the
      table contains a header row.
    remarks: '\[ [API set: ExcelApi 1.3](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showFilterButton?: boolean;'
      return:
        type: boolean
  - name: showHeaders
    uid: 'excel!Excel.Interfaces.TableLoadOptions#showHeaders:member'
    package: excel!
    fullName: showHeaders
    summary: Specifies if the header row is visible. This value can be set to show or remove the header row.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showHeaders?: boolean;'
      return:
        type: boolean
  - name: showTotals
    uid: 'excel!Excel.Interfaces.TableLoadOptions#showTotals:member'
    package: excel!
    fullName: showTotals
    summary: Specifies if the total row is visible. This value can be set to show or remove the total row.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showTotals?: boolean;'
      return:
        type: boolean
  - name: sort
    uid: 'excel!Excel.Interfaces.TableLoadOptions#sort:member'
    package: excel!
    fullName: sort
    summary: Represents the sorting for the table.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'sort?: Excel.Interfaces.TableSortLoadOptions;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.TableSortLoadOptions:interface" />'
  - name: style
    uid: 'excel!Excel.Interfaces.TableLoadOptions#style:member'
    package: excel!
    fullName: style
    summary: >-
      Constant value that represents the table style. Possible values are: "TableStyleLight1" through
      "TableStyleLight21", "TableStyleMedium1" through "TableStyleMedium28", "TableStyleDark1" through
      "TableStyleDark11". A custom user-defined style present in the workbook can also be specified.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'style?: boolean;'
      return:
        type: boolean
  - name: worksheet
    uid: 'excel!Excel.Interfaces.TableLoadOptions#worksheet:member'
    package: excel!
    fullName: worksheet
    summary: The worksheet containing the current table.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'worksheet?: Excel.Interfaces.WorksheetLoadOptions;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.WorksheetLoadOptions:interface" />'