schema-v1.xsd in simple-spreadsheet-extractor-0.7.0

- old
+ new

@@ -5,10 +5,12 @@
 
 	<xsd:element name="workbook" type="Workbook"></xsd:element>
 
 	<xsd:complexType name="Workbook">
 		<xsd:sequence>
+			<xsd:element name="named_ranges" type="NamedRanges" minOccurs="1"
+				maxOccurs="1" />
 			<xsd:element name="styles" type="Styles" minOccurs="1"
 				maxOccurs="1" />
 			<xsd:element name="sheet" type="Sheet" minOccurs="0"
 				maxOccurs="unbounded" />
 		</xsd:sequence>
@@ -49,10 +51,12 @@
 		<xsd:attribute name="id" type="xsd:string" use="required"></xsd:attribute>
 	</xsd:complexType>
 
 	<xsd:complexType name="Sheet">
 		<xsd:sequence>
+			<xsd:element name="data_validations" type="DataValidations" minOccurs="1"
+				maxOccurs="1" />
 			<xsd:element name="columns" type="Columns" minOccurs="1"
 				maxOccurs="1" />
 			<xsd:element name="rows" type="Rows" minOccurs="1"
 				maxOccurs="1" />
 		</xsd:sequence>
@@ -92,10 +96,11 @@
 		<xsd:attribute name="first_row" type="xsd:positiveInteger"
 			use="required"></xsd:attribute>
 		<xsd:attribute name="last_row" type="xsd:positiveInteger"
 			use="required"></xsd:attribute>
 	</xsd:complexType>
+	
 
 	<xsd:complexType name="Row">
 		<xsd:sequence>
 			<xsd:element name="cell" type="Cell" minOccurs="0"
 				maxOccurs="unbounded" />
@@ -118,8 +123,48 @@
 				<xsd:attribute name="type" type="xsd:string" use="required"></xsd:attribute>
 				<xsd:attribute name="formula" type="xsd:string" use="optional"></xsd:attribute>
 				<xsd:attribute name="style" type="xsd:string" use="optional"></xsd:attribute>
 			</xsd:extension>
 		</xsd:simpleContent>
+	</xsd:complexType>
+	
+	<xsd:complexType name="NamedRanges">
+		<xsd:sequence>
+			<xsd:element name="named_range" type="NamedRange" minOccurs="0"
+				maxOccurs="unbounded" />
+		</xsd:sequence>		
+	</xsd:complexType>
+	
+	<xsd:complexType name="NamedRange">		
+		<xsd:sequence>
+			<xsd:element name="name" type="xsd:string" minOccurs="1"
+				maxOccurs="1" />
+			<xsd:element name="sheet_name" type="xsd:string" minOccurs="1"
+				maxOccurs="1" />
+			<xsd:element name="refers_to_formula" type="xsd:string" minOccurs="1"
+				maxOccurs="1" />
+		</xsd:sequence>
+		<xsd:attribute name="first_column" type="xsd:positiveInteger" use="required"></xsd:attribute>
+		<xsd:attribute name="last_column" type="xsd:positiveInteger" use="required"></xsd:attribute>
+		<xsd:attribute name="first_row" type="xsd:positiveInteger" use="required"></xsd:attribute>
+		<xsd:attribute name="last_row" type="xsd:positiveInteger" use="required"></xsd:attribute>
+	</xsd:complexType>
+	
+	<xsd:complexType name="DataValidations">
+		<xsd:sequence>
+			<xsd:element name="data_validation" type="DataValidation" minOccurs="0"
+				maxOccurs="unbounded" />
+		</xsd:sequence>
+	</xsd:complexType>
+	
+	<xsd:complexType name="DataValidation">		
+		<xsd:sequence>
+			<xsd:element name="constraint" type="xsd:string" minOccurs="1"
+				maxOccurs="1" />			
+		</xsd:sequence>
+		<xsd:attribute name="first_column" type="xsd:positiveInteger" use="required"></xsd:attribute>
+		<xsd:attribute name="last_column" type="xsd:positiveInteger" use="required"></xsd:attribute>
+		<xsd:attribute name="first_row" type="xsd:positiveInteger" use="required"></xsd:attribute>
+		<xsd:attribute name="last_row" type="xsd:positiveInteger" use="required"></xsd:attribute>
 	</xsd:complexType>
 
 </xsd:schema>
\ No newline at end of file