WorksheetSource class

Office 2013 and later

Defines the WorksheetSource Class. When the object is serialized out as xml, its qualified name is x:worksheetSource.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

public class WorksheetSource : OpenXmlLeafElement

[ISO/IEC 29500-1 1st Edition]

worksheetSource (Worksheet PivotCache Source)

Represents the location of the source of the data that is stored in the cache.

[Example:

<cacheSource type="worksheet">
  <worksheetSource name="Table1" r:id="rId2"/>
</cacheSource>

end example]

Parent Elements

cacheSource (§18.10.1.7)

Attributes

Description

id (Relationship Id)

Namespace: .../officeDocument/2006/relationships

Specifies the identifier to the Sheet part whose data is stored in the cache. See the Sheet section (§18.2) for more information.

The possible values for this attribute are defined by the ST_RelationshipId simple type (§22.8.2.1).

name (Named Range)

Specifies the named range that is the source of the data.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

ref (Reference)

Specifies the reference that defines a cell range that is the source of the data. This attribute depends on how the application implements cell references.

The possible values for this attribute are defined by the ST_Ref simple type (§18.18.62).

sheet (Sheet Name)

Specifies the name of the sheet that is the source for the cached data.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

[Note: The W3C XML Schema definition of this element’s content model (CT_WorksheetSource) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: