Freigeben über


WorksheetSource-Klasse

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

Vererbungshierarchie

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

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

Syntax

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

Hinweise

[ISO/IEC 29500-1 1. Ausgabe]

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. Die oben aufgeführten Textauszüge wurden von Microsoft (und/oder den Microsoft-Vendoren) von Englisch nach Deutsch übersetzt, und im Rahmen von ISO wird keinerlei Verantwortung für diese Übersetzungen übernommen.

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic) Member dieses Typs sind threadsicher. Bei Instanzmembern ist die Threadsicherheit nicht gewährleistet.

Siehe auch

Referenz

WorksheetSource-Member

DocumentFormat.OpenXml.Spreadsheet-Namespace