WorksheetSource Class

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

Inheritance Hierarchy

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

'Declaration
Public Class WorksheetSource _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As WorksheetSource

public class WorksheetSource : OpenXmlLeafElement

[ISO/IEC 29500-1 1st Edition]

18.10.1.95 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]

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