excel.slicerstylecollection.yml

### YamlMime:TSType
name: Excel.SlicerStyleCollection
uid: 'excel!Excel.SlicerStyleCollection:class'
package: excel!
fullName: Excel.SlicerStyleCollection
summary: Represents a collection of `SlicerStyle` objects.
remarks: '\[ [API set: ExcelApi 1.10](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
type: class
properties:
  - name: context
    uid: 'excel!Excel.SlicerStyleCollection#context:member'
    package: excel!
    fullName: context
    summary: >-
      The request context associated with the object. This connects the add-in's process to the Office host
      application's process.
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'context: RequestContext;'
      return:
        type: '<xref uid="excel!Excel.RequestContext:class" />'
  - name: items
    uid: 'excel!Excel.SlicerStyleCollection#items:member'
    package: excel!
    fullName: items
    summary: Gets the loaded child items in this collection.
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'readonly items: Excel.SlicerStyle[];'
      return:
        type: '<xref uid="excel!Excel.SlicerStyle:class" />[]'
methods:
  - name: 'add(name, makeUniqueName)'
    uid: 'excel!Excel.SlicerStyleCollection#add:member(1)'
    package: excel!
    fullName: 'add(name, makeUniqueName)'
    summary: Creates a blank slicer style with the specified name.
    remarks: '\[ [API set: ExcelApi 1.10](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'add(name: string, makeUniqueName?: boolean): Excel.SlicerStyle;'
      parameters:
        - id: name
          description: >-
            The unique name for the new slicer style. Will throw an `InvalidArgument` exception if the name is already
            in use.
          type: string
        - id: makeUniqueName
          description: >-
            Optional. Defaults to `false`<!-- -->. If `true`<!-- -->, will append numbers to the name in order to make
            it unique, if needed.
          type: boolean
      return:
        type: '<xref uid="excel!Excel.SlicerStyle:class" />'
        description: The newly created `SlicerStyle`<!-- -->.
  - name: getCount()
    uid: 'excel!Excel.SlicerStyleCollection#getCount:member(1)'
    package: excel!
    fullName: getCount()
    summary: Gets the number of slicer styles in the collection.
    remarks: '\[ [API set: ExcelApi 1.10](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'getCount(): OfficeExtension.ClientResult<number>;'
      return:
        type: '<xref uid="office!OfficeExtension.ClientResult:class" />&lt;number&gt;'
        description: ''
  - name: getDefault()
    uid: 'excel!Excel.SlicerStyleCollection#getDefault:member(1)'
    package: excel!
    fullName: getDefault()
    summary: Gets the default `SlicerStyle` for the parent object's scope.
    remarks: '\[ [API set: ExcelApi 1.10](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'getDefault(): Excel.SlicerStyle;'
      return:
        type: '<xref uid="excel!Excel.SlicerStyle:class" />'
        description: The `SlicerStyle` object that is the current default slicer style.
  - name: getItem(name)
    uid: 'excel!Excel.SlicerStyleCollection#getItem:member(1)'
    package: excel!
    fullName: getItem(name)
    summary: Gets a `SlicerStyle` by name.
    remarks: '\[ [API set: ExcelApi 1.10](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'getItem(name: string): Excel.SlicerStyle;'
      parameters:
        - id: name
          description: Name of the slicer style to be retrieved.
          type: string
      return:
        type: '<xref uid="excel!Excel.SlicerStyle:class" />'
        description: The `SlicerStyle` object whose name matches the input.
  - name: getItemOrNullObject(name)
    uid: 'excel!Excel.SlicerStyleCollection#getItemOrNullObject:member(1)'
    package: excel!
    fullName: getItemOrNullObject(name)
    summary: >-
      Gets a `SlicerStyle` by name. If the slicer style doesn't exist, then this method returns an object with its
      `isNullObject` property set to `true`<!-- -->. For further information, see [*OrNullObject methods and
      properties](https://learn.microsoft.com/office/dev/add-ins/develop/application-specific-api-model#ornullobject-methods-and-properties)<!--
      -->.
    remarks: '\[ [API set: ExcelApi 1.10](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'getItemOrNullObject(name: string): Excel.SlicerStyle;'
      parameters:
        - id: name
          description: Name of the slicer style to be retrieved.
          type: string
      return:
        type: '<xref uid="excel!Excel.SlicerStyle:class" />'
        description: The `SlicerStyle` object whose name matches the input.
  - name: load(options)
    uid: 'excel!Excel.SlicerStyleCollection#load:member(1)'
    package: excel!
    fullName: load(options)
    summary: >-
      Queues up a command to load the specified properties of the object. You must call `context.sync()` before reading
      the properties.
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: >-
        load(options?: Excel.Interfaces.SlicerStyleCollectionLoadOptions & Excel.Interfaces.CollectionLoadOptions):
        Excel.SlicerStyleCollection;
      parameters:
        - id: options
          description: Provides options for which properties of the object to load.
          type: >-
            <xref uid="excel!Excel.Interfaces.SlicerStyleCollectionLoadOptions:interface" /> & <xref
            uid="excel!Excel.Interfaces.CollectionLoadOptions:interface" />
      return:
        type: '<xref uid="excel!Excel.SlicerStyleCollection:class" />'
        description: ''
  - name: load(propertyNames)
    uid: 'excel!Excel.SlicerStyleCollection#load:member(2)'
    package: excel!
    fullName: load(propertyNames)
    summary: >-
      Queues up a command to load the specified properties of the object. You must call `context.sync()` before reading
      the properties.
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'load(propertyNames?: string | string[]): Excel.SlicerStyleCollection;'
      parameters:
        - id: propertyNames
          description: A comma-delimited string or an array of strings that specify the properties to load.
          type: 'string | string[]'
      return:
        type: '<xref uid="excel!Excel.SlicerStyleCollection:class" />'
        description: ''
  - name: load(propertyNamesAndPaths)
    uid: 'excel!Excel.SlicerStyleCollection#load:member(3)'
    package: excel!
    fullName: load(propertyNamesAndPaths)
    summary: >-
      Queues up a command to load the specified properties of the object. You must call `context.sync()` before reading
      the properties.
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'load(propertyNamesAndPaths?: OfficeExtension.LoadOption): Excel.SlicerStyleCollection;'
      parameters:
        - id: propertyNamesAndPaths
          description: >-
            `propertyNamesAndPaths.select` is a comma-delimited string that specifies the properties to load, and
            `propertyNamesAndPaths.expand` is a comma-delimited string that specifies the navigation properties to load.
          type: '<xref uid="office!OfficeExtension.LoadOption:interface" />'
      return:
        type: '<xref uid="excel!Excel.SlicerStyleCollection:class" />'
        description: ''
  - name: setDefault(newDefaultStyle)
    uid: 'excel!Excel.SlicerStyleCollection#setDefault:member(1)'
    package: excel!
    fullName: setDefault(newDefaultStyle)
    summary: Sets the default slicer style for use in the parent object's scope.
    remarks: '\[ [API set: ExcelApi 1.10](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'setDefault(newDefaultStyle: SlicerStyle | string): void;'
      parameters:
        - id: newDefaultStyle
          description: 'The `SlicerStyle` object, or name of the `SlicerStyle` object, that should be the new default.'
          type: '<xref uid="excel!Excel.SlicerStyle:class" /> | string'
      return:
        type: void
        description: ''
  - name: toJSON()
    uid: 'excel!Excel.SlicerStyleCollection#toJSON:member(1)'
    package: excel!
    fullName: toJSON()
    summary: >-
      Overrides the JavaScript `toJSON()` method in order to provide more useful output when an API object is passed to
      `JSON.stringify()`<!-- -->. (`JSON.stringify`<!-- -->, in turn, calls the `toJSON` method of the object that is
      passed to it.) Whereas the original `Excel.SlicerStyleCollection` object is an API object, the `toJSON` method
      returns a plain JavaScript object (typed as `Excel.Interfaces.SlicerStyleCollectionData`<!-- -->) that contains an
      "items" array with shallow copies of any loaded properties from the collection's items.
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'toJSON(): Excel.Interfaces.SlicerStyleCollectionData;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.SlicerStyleCollectionData:interface" />'
        description: ''
extends: '<xref uid="office!OfficeExtension.ClientObject:class" />'