Поделиться через


WorksheetSource Class

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

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Spreadsheet.WorksheetSource

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

Syntax

'Декларация
Public Class WorksheetSource _
    Inherits OpenXmlLeafElement
'Применение
Dim instance As WorksheetSource
public class WorksheetSource : OpenXmlLeafElement

Remarks

[ISO/IEC 29500-1 редакция 1]

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]

© ISO/IEC29500: 2008. Приведенный выше текст переведен с английского языка на русский корпорацией Майкрософт (или ее подрядчиками) и ISO не несет ответственности за эти переводы.

Thread Safety

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

See Also

Reference

WorksheetSource Members

DocumentFormat.OpenXml.Spreadsheet Namespace