次の方法で共有


DataValidations Class

Defines the DataValidations Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:dataValidations.

Inheritance Hierarchy

System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office2010.Excel.DataValidations

Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'宣言
<ChildElementInfoAttribute(GetType(DataValidation), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class DataValidations _
    Inherits OpenXmlCompositeElement
'使用
Dim instance As DataValidations
[ChildElementInfoAttribute(typeof(DataValidation), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class DataValidations : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • DataValidation <x14:dataValidation>

2.4.5 dataValidations

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

A CT_DataValidations element that specifies a group of data validation items on the sheet. This element also specifies data validation properties of a sheet that are used by the Application UI. See Worksheet under Extensions by Part for how this element integrates with [ISO/IEC-29500-1].

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

<xsd:element name="dataValidations" type="CT_DataValidations"/>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.3 CT_DataValidations

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

Referenced by: dataValidations

A complex type that specifies a group of data validation items on the sheet. MUST contain less than or equal to 65534 elements. This complex type also specifies data validation properties of a sheet that are used by the Application UI.

Child Elements:

dataValidation : A CT_DataValidation element that specifies the properties for a single item of data validation defined on a range of the sheet.

Attributes:

disablePrompts : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether all data validation input prompts are disabled for this sheet.

xWindow : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the x-coordinate (relative to the Application window) of the top-left corner of the data validation input prompt, measured in pixels. This value MUST be less than or equal to 65535. <11>

yWindow : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the y-coordinate (relative to the Application window) of the top-left corner of the data validation input prompt, measured in pixels. This value MUST be less than or equal to 65535. <12>

count : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of dataValidation children of this element.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_DataValidations">

<xsd:sequence>

<xsd:element name="dataValidation" type="CT_DataValidation" minOccurs="1" maxOccurs="unbounded"/>

</xsd:sequence>

<xsd:attribute name="disablePrompts" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="xWindow" type="xsd:unsignedInt" use="optional"/>

<xsd:attribute name="yWindow" type="xsd:unsignedInt" use="optional"/>

<xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>

</xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

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

DataValidations Members

DocumentFormat.OpenXml.Office2010.Excel Namespace