OA2021/ExcelReaderWrite/ExcelSchema.cs

//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated by a tool.
//     Runtime Version:2.0.50727.42
//
//     Changes to this file may cause incorrect behavior and will be lost if
//     the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

using System;
using System.ComponentModel;
using System.Diagnostics;
using System.CodeDom.Compiler;
using System.Xml.Serialization;

// 
// This source code was auto-generated by xsd, Version=2.0.50727.42.
// 

namespace ExcelReaderWrite
{
  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [DebuggerStepThroughAttribute]
  [DesignerCategoryAttribute("code")]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd", AnonymousType = true)]
  [XmlRootAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd", IsNullable = false)]
  public class ReportTemplete {
    private FixedSection[] fixedSectionField;

    private ExtendableSection[] extendableSectionField;

    private string templeteFileField;

    /// <remarks/>
    [XmlElementAttribute("FixedSection")]
    public FixedSection[] FixedSection {
      get {
        return fixedSectionField;
      }
      set {
        fixedSectionField = value;
      }
    }

    /// <remarks/>
    [XmlElementAttribute("ExtendableSection")]
    public ExtendableSection[] ExtendableSection {
      get {
        return extendableSectionField;
      }
      set {
        extendableSectionField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string TempleteFile {
      get {
        return templeteFileField;
      }
      set {
        templeteFileField = value;
      }
    }
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [DebuggerStepThroughAttribute]
  [DesignerCategoryAttribute("code")]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public class FixedSection {
    private Cell[] cellField;

    private UnitCell[] unitCellField;

    private string describeField;

    private string nameField;

    private string sheetNameField;

    private string nullStringField;

    private string replateEndPostionField;

    private string replateStartPostionField;

    private bool rotateField;

    public FixedSection() {
      nullStringField = "";
      rotateField = false;
    }

    /// <remarks/>
    [XmlElementAttribute("Cell")]
    public Cell[] Cell {
      get {
        return cellField;
      }
      set {
        cellField = value;
      }
    }

    /// <remarks/>
    [XmlElementAttribute("UnitCell")]
    public UnitCell[] UnitCell {
      get {
        return unitCellField;
      }
      set {
        unitCellField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string Describe {
      get {
        return describeField;
      }
      set {
        describeField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string Name {
      get {
        return nameField;
      }
      set {
        nameField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string SheetName {
      get {
        return sheetNameField;
      }
      set {
        sheetNameField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute("0")]
    public string NullString {
      get {
        return nullStringField;
      }
      set {
        nullStringField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string ReplateEndPostion {
      get {
        return replateEndPostionField;
      }
      set {
        replateEndPostionField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string ReplateStartPostion {
      get {
        return replateStartPostionField;
      }
      set {
        replateStartPostionField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(false)]
    public bool Rotate {
      get {
        return rotateField;
      }
      set {
        rotateField = value;
      }
    }
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [DebuggerStepThroughAttribute]
  [DesignerCategoryAttribute("code")]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public class Cell {
    private string positionField;

    private string dataNameField;

    private string describeField;

    private string validationExpression;

    private bool validationEmpty;

    /// <remarks/>
    [XmlAttributeAttribute]
    public string Position {
      get {
        return positionField;
      }
      set {
        positionField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string DataName {
      get {
        return dataNameField;
      }
      set {
        dataNameField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string Describe {
      get {
        return describeField;
      }
      set {
        describeField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string ValidationExpression {
      get {
        return validationExpression;
      }
      set {
        validationExpression = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(false)]
    public bool ValidationEmpty {
      get {
        return validationEmpty;
      }
      set {
        validationEmpty = value;
      }
    }
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [DebuggerStepThroughAttribute]
  [DesignerCategoryAttribute("code")]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public class RowDefine {
    private string dataNameField;

    private string describeField;

    private string positionField;

    private string validationExpression;

    private bool validationEmpty;

    private bool unique;

    /// <remarks/>
    [XmlAttributeAttribute]
    public string DataName {
      get {
        return dataNameField;
      }
      set {
        dataNameField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string Describe {
      get {
        return describeField;
      }
      set {
        describeField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string Position {
      get {
        return positionField;
      }
      set {
        positionField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string ValidationExpression {
      get {
        return validationExpression;
      }
      set {
        validationExpression = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(false)]
    public bool ValidationEmpty {
      get {
        return validationEmpty;
      }
      set {
        validationEmpty = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(false)]
    public bool Unique {
      get {
        return unique;
      }
      set {
        unique = value;
      }
    }
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [DebuggerStepThroughAttribute]
  [DesignerCategoryAttribute("code")]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public class ExtendableSection {
    private RowDefine[] rowDefineField;

    private string sheetNameField;

    private string nameField;

    private string descirbeField;

    private string positionField;

    private bool rotateField;

    private string nullStringField;

    private string downloadMaxCountField;

    private string uploadMaxCountField;

    public ExtendableSection() {
      rotateField = true;
      nullStringField = "";
    }

    /// <remarks/>
    [XmlElementAttribute("RowDefine")]
    public RowDefine[] RowDefine {
      get {
        return rowDefineField;
      }
      set {
        rowDefineField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string SheetName {
      get {
        return sheetNameField;
      }
      set {
        sheetNameField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string Name {
      get {
        return nameField;
      }
      set {
        nameField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string Descirbe {
      get {
        return descirbeField;
      }
      set {
        descirbeField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string Position {
      get {
        return positionField;
      }
      set {
        positionField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(true)]
    public bool Rotate {
      get {
        return rotateField;
      }
      set {
        rotateField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute("0")]
    public string NullString {
      get {
        return nullStringField;
      }
      set {
        nullStringField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute("")]
    public string DownloadMaxCount {
      get {
        return downloadMaxCountField;
      }
      set {
        downloadMaxCountField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute("")]
    public string UploadMaxCount {
      get {
        return uploadMaxCountField;
      }
      set {
        uploadMaxCountField = value;
      }
    }
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [DebuggerStepThroughAttribute]
  [DesignerCategoryAttribute("code")]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public class BorderInfo {
    private BorderWeight borderWeightField;

    private Color borderColorField;

    private BorderEdge borderEdgeField;

    private LineStype lineStypeField;

    public BorderInfo() {
      borderWeightField = BorderWeight.xlNone;
      borderColorField = Color.Black;
      lineStypeField = LineStype.xlNone;
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(BorderWeight.xlNone)]
    public BorderWeight BorderWeight {
      get {
        return borderWeightField;
      }
      set {
        borderWeightField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(Color.Black)]
    public Color BorderColor {
      get {
        return borderColorField;
      }
      set {
        borderColorField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public BorderEdge BorderEdge {
      get {
        return borderEdgeField;
      }
      set {
        borderEdgeField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(LineStype.xlNone)]
    public LineStype LineStype {
      get {
        return lineStypeField;
      }
      set {
        lineStypeField = value;
      }
    }
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public enum BorderWeight {
    /// <remarks/>
    xlThin,

    /// <remarks/>
    xlThick,

    /// <remarks/>
    xlMedium,

    /// <remarks/>
    xlHairline,

    /// <remarks/>
    xlNone,
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public enum Color {
    /// <remarks/>
    None,

    /// <remarks/>
    Auto,

    /// <remarks/>
    Black,

    /// <remarks/>
    Brown,

    /// <remarks/>
    Olive,

    /// <remarks/>
    DeepLime,

    /// <remarks/>
    DeepGreen,

    /// <remarks/>
    DeepBlue,

    /// <remarks/>
    DarkBlue,

    /// <remarks/>
    Gray80,

    /// <remarks/>
    DeepRed,

    /// <remarks/>
    Orange,

    /// <remarks/>
    DeepOrange,

    /// <remarks/>
    Green,

    /// <remarks/>
    Lime,

    /// <remarks/>
    Blue,

    /// <remarks/>
    BlueGray,

    /// <remarks/>
    Gray50,

    /// <remarks/>
    Red,

    /// <remarks/>
    LightOrange,

    /// <remarks/>
    SliverOrange,

    /// <remarks/>
    SeaGreen,

    /// <remarks/>
    WaterGreen,

    /// <remarks/>
    LittleBlue,

    /// <remarks/>
    Violet,

    /// <remarks/>
    Gray40,

    /// <remarks/>
    Pink,

    /// <remarks/>
    Golden,

    /// <remarks/>
    Yellow,

    /// <remarks/>
    SpringGreen,

    /// <remarks/>
    LimeGreen,

    /// <remarks/>
    SkyBlue,

    /// <remarks/>
    Crimson,

    /// <remarks/>
    Gray25,

    /// <remarks/>
    Rose,

    /// <remarks/>
    Tea,

    /// <remarks/>
    LightYellow,

    /// <remarks/>
    LightGreen,

    /// <remarks/>
    LightLimeGreen,

    /// <remarks/>
    LightBlue,

    /// <remarks/>
    lilac,

    /// <remarks/>
    White,
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public enum BorderEdge {
    /// <remarks/>
    xlEdgeTop,

    /// <remarks/>
    xlEdgeBottom,

    /// <remarks/>
    xlEdgeLeft,

    /// <remarks/>
    xlEdgeRight,

    /// <remarks/>
    xlInsideHorizontal,

    /// <remarks/>
    xlInsideVertical,

    /// <remarks/>
    xlDiagonalDown,

    /// <remarks/>
    xlDiagonalUp,
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public enum LineStype {
    /// <remarks/>
    xlContinuous,

    /// <remarks/>
    xlDash,

    /// <remarks/>
    xlDashDot,

    /// <remarks/>
    xlDashDotDot,

    /// <remarks/>
    xlDot,

    /// <remarks/>
    xlDoubleLine,

    /// <remarks/>
    xlNone,

    /// <remarks/>
    xlSlantDashDot,
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [DebuggerStepThroughAttribute]
  [DesignerCategoryAttribute("code")]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public class ImageInfo {
    private string imagePathField;

    private decimal imageWidthField;

    private decimal imageHeightField;

    private decimal paddLeftTopField;

    public ImageInfo() {
      imageWidthField = 0m;
      imageHeightField = 0m;
      paddLeftTopField = 0.0m;
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string ImagePath {
      get {
        return imagePathField;
      }
      set {
        imagePathField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(typeof(decimal), "0")]
    public decimal ImageWidth {
      get {
        return imageWidthField;
      }
      set {
        imageWidthField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(typeof(decimal), "0")]
    public decimal ImageHeight {
      get {
        return imageHeightField;
      }
      set {
        imageHeightField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(typeof(decimal), "0.0")]
    public decimal PaddLeftTop {
      get {
        return paddLeftTopField;
      }
      set {
        paddLeftTopField = value;
      }
    }
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [DebuggerStepThroughAttribute]
  [DesignerCategoryAttribute("code")]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public class FontInfo {
    private string fontNameField;

    private Color fontColorField;

    private bool isBoldField;

    private string fontSizeField;

    private UnderLine underLineField;

    private bool isItalicField;

    private string orientation;

    public FontInfo() {
      fontColorField = Color.None;
      isBoldField = false;
      underLineField = UnderLine.xlNone;
      isItalicField = false;
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string FontName {
      get {
        return fontNameField;
      }
      set {
        fontNameField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string Orientation {
      get {
        return orientation;
      }
      set {
        orientation = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(Color.None)]
    public Color FontColor {
      get {
        return fontColorField;
      }
      set {
        fontColorField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(false)]
    public bool IsBold {
      get {
        return isBoldField;
      }
      set {
        isBoldField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string FontSize {
      get {
        return fontSizeField;
      }
      set {
        fontSizeField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(UnderLine.xlNone)]
    public UnderLine UnderLine {
      get {
        return underLineField;
      }
      set {
        underLineField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(false)]
    public bool IsItalic {
      get {
        return isItalicField;
      }
      set {
        isItalicField = value;
      }
    }
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public enum UnderLine {
    /// <remarks/>
    xlNone,

    /// <remarks/>
    xlDouble,

    /// <remarks/>
    xlDoubleFill,

    /// <remarks/>
    xlSingle,

    /// <remarks/>
    xlSingleFill,
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [DebuggerStepThroughAttribute]
  [DesignerCategoryAttribute("code")]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public class UnitCell {
    private FontInfo fontInfoField;

    private ImageInfo imageInfoField;

    private BorderInfo[] borderInfoField;

    private string startPointField;

    private string endPointField;

    private string textField;

    private VAlign vAlignField;

    private HAlign hAlignField;

    private Color backColorField;

    private string describeField;

    private bool isImageField;

    public UnitCell() {
      textField = " ";
      vAlignField = VAlign.xlVAlignCenter;
      hAlignField = HAlign.xlHAlignCenter;
      backColorField = Color.None;
      isImageField = false;
    }

    /// <remarks/>
    public FontInfo FontInfo {
      get {
        return fontInfoField;
      }
      set {
        fontInfoField = value;
      }
    }

    /// <remarks/>
    public ImageInfo ImageInfo {
      get {
        return imageInfoField;
      }
      set {
        imageInfoField = value;
      }
    }

    /// <remarks/>
    [XmlElementAttribute("BorderInfo")]
    public BorderInfo[] BorderInfo {
      get {
        return borderInfoField;
      }
      set {
        borderInfoField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string StartPoint {
      get {
        return startPointField;
      }
      set {
        startPointField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string EndPoint {
      get {
        return endPointField;
      }
      set {
        endPointField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(" ")]
    public string Text {
      get {
        return textField;
      }
      set {
        textField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(VAlign.xlVAlignCenter)]
    public VAlign VAlign {
      get {
        return vAlignField;
      }
      set {
        vAlignField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(HAlign.xlHAlignCenter)]
    public HAlign HAlign {
      get {
        return hAlignField;
      }
      set {
        hAlignField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(Color.None)]
    public Color BackColor {
      get {
        return backColorField;
      }
      set {
        backColorField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    public string Describe {
      get {
        return describeField;
      }
      set {
        describeField = value;
      }
    }

    /// <remarks/>
    [XmlAttributeAttribute]
    [DefaultValueAttribute(false)]
    public bool IsImage {
      get {
        return isImageField;
      }
      set {
        isImageField = value;
      }
    }
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public enum VAlign {
    /// <remarks/>
    xlVAlignTop,

    /// <remarks/>
    xlVAlignCenter,

    /// <remarks/>
    xlVAlignBottom,

    /// <remarks/>
    xlVAlignJustify,

    /// <remarks/>
    xlVAlignDistributed,
  }

  /// <remarks/>
  [GeneratedCodeAttribute("xsd", "2.0.50727.42")]
  [SerializableAttribute]
  [XmlTypeAttribute(Namespace = "http://ttnic.org/ExcelSchema.xsd")]
  public enum HAlign {
    /// <remarks/>
    xlHAlignGeneral,

    /// <remarks/>
    xlHAlignLeft,

    /// <remarks/>
    xlHAlignCenter,

    /// <remarks/>
    xlHAlignRight,

    /// <remarks/>
    xlHAlignFill,

    /// <remarks/>
    xlHAlignJustify,

    /// <remarks/>
    xlHAlignCenterAcrossSelection,

    /// <remarks/>
    xlHAlignDistributed,
  }
}