OA2021/ExcelReaderWrite/ExcelSchema.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ExcelSchema" targetNamespace="http://ttnic.org/ExcelSchema.xsd" elementFormDefault="qualified" xmlns="http://ttnic.org/ExcelSchema.xsd" xmlns:mstns="http://ttnic.org/ExcelSchema.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="ReportTemplete">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="ExtendableSection" type="ExtendableSection" maxOccurs="unbounded" minOccurs="0" />
        <xs:element name="FixedSection" type="FixedSection" minOccurs="0" maxOccurs="unbounded" />
      </xs:sequence>
      <xs:attribute name="TempleteFile" type="xs:string" use="required" />
    </xs:complexType>
  </xs:element>
  <xs:complexType name="FixedSection">
    <xs:sequence>
      <xs:element name="Cell" type="Cell" minOccurs="1" maxOccurs="unbounded" />
      <xs:element name="UnitCell" type="UnitCell" maxOccurs="unbounded" minOccurs="0" />
    </xs:sequence>
    <xs:attribute name="Name" type="xs:string" use="required" />
    <xs:attribute name="Describe" type="xs:string" use="optional" />
    <xs:attribute name="SheetName" type="xs:string" use="required" />
    <xs:attribute name="NullString" type="xs:string" default="0" use="optional" />
    <xs:attribute name="Rotate" type="xs:boolean" default="false" use="optional" />
    <xs:attribute name="ReplateEndPostion" type="xs:string" use="optional" />
    <xs:attribute name="ReplateStartPostion" type="xs:string" use="optional" />
  </xs:complexType>
  <xs:complexType name="Cell">
    <xs:sequence>
    </xs:sequence>
    <xs:attribute name="Position" type="xs:string" use="required" />
    <xs:attribute name="DataName" type="xs:string" use="required" />
    <xs:attribute name="Describe" type="xs:string" use="optional" />
    <xs:attribute name="ValidationEmpty" type="xs:boolean" default="false" use="optional" />
    <xs:attribute name="ValidationExpression" type="xs:string" use="optional" />
  </xs:complexType>
  <xs:complexType name="UnitCell">
    <xs:sequence>
      <xs:element name="FontInfo" type="FontInfo" maxOccurs="1" minOccurs="0" />
      <xs:element name="ImageInfo" type="ImageInfo" maxOccurs="1" minOccurs="0" />
      <xs:element name="BorderInfo" type="BorderInfo" maxOccurs="unbounded" minOccurs="0" />
    </xs:sequence>
    <xs:attribute name="StartPoint" type="xs:string" use="required" />
    <xs:attribute name="EndPoint" type="xs:string" use="required" />
    <xs:attribute name="Text" type="xs:string" default=" " />
    <xs:attribute name="VAlign" type="VAlign" default="xlVAlignCenter" />
    <xs:attribute name="HAlign" type="HAlign" default="xlHAlignCenter" />
    <xs:attribute name="BackColor" type="Color" default="None" />
    <xs:attribute name="Describe" type="xs:string" />
    <xs:attribute name="IsImage" type="xs:boolean" default="false" />
  </xs:complexType>
  <xs:complexType name="ExtendableSection">
    <xs:sequence>
      <xs:element name="RowDefine" type="RowDefine" maxOccurs="unbounded" minOccurs="1" />
    </xs:sequence>
    <xs:attribute name="Name" type="xs:string" use="required" />
    <xs:attribute name="Descirbe" type="xs:string" use="optional" />
    <xs:attribute name="SheetName" type="xs:string" use="required" />
    <xs:attribute name="NullString" type="xs:string" default="0" use="optional" />
    <xs:attribute name="Rotate" type="xs:boolean" default="true" use="optional" />
    <xs:attribute name="Position" type="xs:string" use="optional" />
    <xs:attribute name="DownloadMaxCount" type="xs:string" default="" use="optional" />
    <xs:attribute name="UploadMaxCount" type="xs:string" default="" use="optional" />
  </xs:complexType>
  <xs:complexType name="RowDefine">
    <xs:sequence>
    </xs:sequence>
    <xs:attribute name="DataName" type="xs:string" use="required" />
    <xs:attribute name="Describe" type="xs:string" use="optional" />
    <xs:attribute name="Position" type="xs:string" use="optional" />
    <xs:attribute name="ValidationEmpty" type="xs:boolean" default="false" use="optional" />
    <xs:attribute name="ValidationExpression" type="xs:string" use="optional" />
    <xs:attribute name="Unique" type="xs:boolean" default="false" use="optional" />
  </xs:complexType>
  <xs:complexType name="FontInfo">
    <xs:sequence>
    </xs:sequence>
    <xs:attribute name="FontName" type="xs:string" />
    <xs:attribute name="FontColor" type="Color" default="None" />
    <xs:attribute name="IsBold" type="xs:boolean" default="false" />
    <xs:attribute name="FontSize" type="xs:string" />
    <xs:attribute name="UnderLine" type="UnderLine" default="xlNone" />
    <xs:attribute name="IsItalic" type="xs:boolean" default="false" />
    <xs:attribute name="Orientation" type="xs:string" default="0" />
  </xs:complexType>
  <xs:complexType name="ImageInfo">
    <xs:sequence>
    </xs:sequence>
    <xs:attribute name="ImagePath" type="xs:string" use="required" />
    <xs:attribute name="ImageWidth" type="xs:decimal" default="0" />
    <xs:attribute name="ImageHeight" type="xs:decimal" default="0" />
    <xs:attribute name="PaddLeftTop" type="xs:decimal" default="0.0" />
  </xs:complexType>
  <xs:complexType name="BorderInfo">
    <xs:sequence>
    </xs:sequence>
    <xs:attribute name="BorderWeight" type="BorderWeight" default="xlNone" />
    <xs:attribute name="BorderColor" type="Color" default="Black" />
    <xs:attribute name="BorderEdge" type="BorderEdge" use="required" />
    <xs:attribute name="LineStype" type="LineStype" default="xlNone" />
  </xs:complexType>
  <xs:simpleType name="BorderEdge">
    <xs:restriction base="xs:string">
      <xs:enumeration value="xlEdgeTop" />
      <xs:enumeration value="xlEdgeBottom" />
      <xs:enumeration value="xlEdgeLeft" />
      <xs:enumeration value="xlEdgeRight" />
      <xs:enumeration value="xlInsideHorizontal" />
      <xs:enumeration value="xlInsideVertical" />
      <xs:enumeration value="xlDiagonalDown" />
      <xs:enumeration value="xlDiagonalUp" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="LineStype">
    <xs:restriction base="xs:string">
      <xs:enumeration value="xlContinuous" />
      <xs:enumeration value="xlDash" />
      <xs:enumeration value="xlDashDot" />
      <xs:enumeration value="xlDashDotDot" />
      <xs:enumeration value="xlDot" />
      <xs:enumeration value="xlDoubleLine" />
      <xs:enumeration value="xlNone" />
      <xs:enumeration value="xlSlantDashDot" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="BorderWeight">
    <xs:restriction base="xs:string">
      <xs:enumeration value="xlThin" />
      <xs:enumeration value="xlThick" />
      <xs:enumeration value="xlMedium" />
      <xs:enumeration value="xlHairline" />
      <xs:enumeration value="xlNone" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="UnderLine">
    <xs:restriction base="xs:string">
      <xs:enumeration value="xlNone" />
      <xs:enumeration value="xlDouble" />
      <xs:enumeration value="xlDoubleFill" />
      <xs:enumeration value="xlSingle" />
      <xs:enumeration value="xlSingleFill" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="VAlign">
    <xs:restriction base="xs:string">
      <xs:enumeration value="xlVAlignTop" />
      <xs:enumeration value="xlVAlignCenter" />
      <xs:enumeration value="xlVAlignBottom" />
      <xs:enumeration value="xlVAlignJustify" />
      <xs:enumeration value="xlVAlignDistributed" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="HAlign">
    <xs:restriction base="xs:string">
      <xs:enumeration value="xlHAlignGeneral" />
      <xs:enumeration value="xlHAlignLeft" />
      <xs:enumeration value="xlHAlignCenter" />
      <xs:enumeration value="xlHAlignRight" />
      <xs:enumeration value="xlHAlignFill" />
      <xs:enumeration value="xlHAlignJustify" />
      <xs:enumeration value="xlHAlignCenterAcrossSelection" />
      <xs:enumeration value="xlHAlignDistributed" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="Color">
    <xs:restriction base="xs:string">
      <xs:enumeration value="None" />
      <xs:enumeration value="Auto" />
      <xs:enumeration value="Black" />
      <xs:enumeration value="Brown" />
      <xs:enumeration value="Olive" />
      <xs:enumeration value="DeepLime" />
      <xs:enumeration value="DeepGreen" />
      <xs:enumeration value="DeepBlue" />
      <xs:enumeration value="DarkBlue" />
      <xs:enumeration value="Gray80" />
      <xs:enumeration value="DeepRed" />
      <xs:enumeration value="Orange" />
      <xs:enumeration value="DeepOrange" />
      <xs:enumeration value="Green" />
      <xs:enumeration value="Lime" />
      <xs:enumeration value="Blue" />
      <xs:enumeration value="BlueGray" />
      <xs:enumeration value="Gray50" />
      <xs:enumeration value="Red" />
      <xs:enumeration value="LightOrange" />
      <xs:enumeration value="SliverOrange" />
      <xs:enumeration value="SeaGreen" />
      <xs:enumeration value="WaterGreen" />
      <xs:enumeration value="LittleBlue" />
      <xs:enumeration value="Violet" />
      <xs:enumeration value="Gray40" />
      <xs:enumeration value="Pink" />
      <xs:enumeration value="Golden" />
      <xs:enumeration value="Yellow" />
      <xs:enumeration value="SpringGreen" />
      <xs:enumeration value="LimeGreen" />
      <xs:enumeration value="SkyBlue" />
      <xs:enumeration value="Crimson" />
      <xs:enumeration value="Gray25" />
      <xs:enumeration value="Rose" />
      <xs:enumeration value="Tea" />
      <xs:enumeration value="LightYellow" />
      <xs:enumeration value="LightGreen" />
      <xs:enumeration value="LightLimeGreen" />
      <xs:enumeration value="LightBlue" />
      <xs:enumeration value="lilac" />
      <xs:enumeration value="White" />
    </xs:restriction>
  </xs:simpleType>
</xs:schema>