qexport4xlscommon.pas

Advanced.Export.Component.v4.01.rar,delphi 第三方控件

  TCHART_PLOTGROWTH = packed record
    Horizontal: cardinal;
    Vertical  : cardinal;
  end;

  PCHART_FRAME = ^TCHART_FRAME;
  TCHART_FRAME = packed record
    FrameType: word;
    Flags: word;
  end;

  PCHART_LINEFORMAT = ^TCHART_LINEFORMAT;
  TCHART_LINEFORMAT = packed record
    Color      : cardinal;
    Pattern    : word;
    Weight     : word;
    FormatFlags: word;
    ColorIndex : word;
  end;

  PCHART_AREAFORMAT = ^TCHART_AREAFORMAT;
  TCHART_AREAFORMAT = packed record
    ForegroundColor     : cardinal;
    BackgroundColor     : cardinal;
    Pattern             : word;
    FormatFlags         : word;
    ForegroundColorIndex: word;
    BackgroundColorIndex: word;
  end;

  PCHART_SERIES = ^TCHART_SERIES;
  TCHART_SERIES = packed record
    CategoryType : word;
    ValueType    : word;
    CategoryCount: word;
    ValueCount   : word;
    BubbleType   : word;
    BubbleCount  : word;
  end;

  PCHART_AI = ^TCHART_AI;
  TCHART_AI = packed record
    LinkType     : byte;
    ReferenceType: byte;
    Flags        : word;
    FormatIndex  : word;
    FormulaSize  : word;
  end;

  PCHART_PTG_AREA3D = ^TCHART_PTG_AREA3D;
  TCHART_PTG_AREA3D = packed record
    ID: byte;
    PTG_AREA3D: TPTG_AREA3D;
  end;

  PCHART_SERIESTEXT = ^TCHART_SERIESTEXT;
  TCHART_SERIESTEXT = packed record
    TextID: word;
    Length: byte;
  end;

  PCHART_DATAFORMAT = ^TCHART_DATAFORMAT;
  TCHART_DATAFORMAT = packed record
    PointNumber : word;
    SeriesIndex : word;
    SeriesNumber: word;
    FormatFlags : word;
  end;

  PCHART_SERTOCRT = ^TCHART_SERTOCRT;
  TCHART_SERTOCRT = packed record
    ChartGroupIndex: word;
  end;

  PCHART_SHTPROPS = ^TCHART_SHTPROPS;
  TCHART_SHTPROPS = packed record
    PropertyFlags: word;
    EmptyAs      : byte;
    Unknown      : byte;
  end;

  PCHART_DEFAULTTEXT = ^TCHART_DEFAULTTEXT;
  TCHART_DEFAULTTEXT = packed record
    ObjectID: word;
  end;

  PCHART_TEXT = ^TCHART_TEXT;
  TCHART_TEXT = packed record
    HorizontalAlignment: byte;
    VerticalAlignment  : byte;
    BackgroundMode     : word;
    Color              : cardinal;
    Left               : cardinal;
    Top                : cardinal;
    Width              : cardinal;
    Height             : cardinal;
    OptionFlags1       : word;
    ColorIndex         : word;
    OptionFlags2       : word;
    Rotation           : word;
  end;

  PCHART_POS = ^TCHART_POS;
  TCHART_POS = packed record
    TopLt: word;
    BotRt: word;
    X1   : cardinal;
    Y1   : cardinal;
    X2   : cardinal;
    Y2   : cardinal;
  end;

  PCHART_FONTX = ^TCHART_FONTX;
  TCHART_FONTX = packed record
    FontIndex: word;
  end;

  PCHART_AXESUSED = ^TCHART_AXESUSED;
  TCHART_AXESUSED = packed record
    AxesCount: word;
  end;

  PCHART_AXISPARENT = ^TCHART_AXISPARENT;
  TCHART_AXISPARENT = packed record
    AxisIndex: word;
    Top      : cardinal;
    Left     : cardinal;
    Width    : cardinal;
    Height   : cardinal;
  end;

  PCHART_AXIS = ^TCHART_AXIS;
  TCHART_AXIS = packed record
    AxisType: word;
    Reserved: array[0..15] of byte;
  end;

  PCHART_CATSERRANGE = ^TCHART_CATSERRANGE;
  TCHART_CATSERRANGE = packed record
    CrossingPoint  : word;
    FrequencyLabels: word;
    FrequencyMarks : word;
    FormatFlags    : word;
  end;

  PCHART_AXCEXT = ^TCHART_AXCEXT;
  TCHART_AXCEXT = packed record
    MinCategory  : word;
    MaxCategory  : word;
    MajorValue   : word;
    MajorUnits   : word;
    MinorValue   : word;
    MinorUnits   : word;
    BaseUnit     : word;
    CrossingPoint: word;
    OptionFlags  : word;
  end;

  PCHART_TICK = ^TCHART_TICK;
  TCHART_TICK = packed record
    MajorMarkType : byte;
    MinorMarkType : byte;
    LabelPosition : byte;
    BackgroundMode: byte;
    Color         : cardinal;
    Reserved1     : array[0..15] of byte;
    DisplayFlags  : word;
    ColorIndex    : word;
    Reserved2     : word;
  end;

  PCHART_VALUERANGE = ^TCHART_VALUERANGE;
  TCHART_VALUERANGE = packed record
    MinValue    : double;
    MaxValue    : double;
    MajorInc    : double;
    MinorInc    : double;
    AxisCrosses : double;
    FormatFlags : word;
  end;

  PCHART_AXISLINEFORMAT = ^TCHART_AXISLINEFORMAT;
  TCHART_AXISLINEFORMAT = packed record
    LineID: word;
  end;

  PCHART_CHARTFORMAT = ^TCHART_CHARTFORMAT;
  TCHART_CHARTFORMAT = packed record
    Reserved    : array[0..15] of byte;
    FormatFlags : word;
    DrawingOrder: word;
  end;

  PCHART_BAR = ^TCHART_BAR;
  TCHART_BAR = packed record
    SpaceBars: word;
    SpaceCategories: word;
    FormatFlags: word;
  end;

  PCHART_LINE = ^TCHART_LINE;
  TCHART_LINE = packed record
    FormatFlags: word;
  end;

  PCHART_PIE = ^TCHART_PIE;
  TCHART_PIE = packed record
    Angle: word;
    Donut: word;
    OptionFlags: word;
  end;

  PCHART_AREA = ^TCHART_AREA;
  TCHART_AREA = packed record
    FormatFlags: word;
  end;

  PCHART_SURFACE = ^TCHART_SURFACE;
  TCHART_SURFACE = packed record
    OptionFlags: word;
  end;

  PCHART_RADAR = ^TCHART_RADAR;
  TCHART_RADAR = packed record
    OptionFlags: word;
  end;

  PCHART_RADARAREA = ^TCHART_RADARAREA;
  TCHART_RADARAREA = packed record
    OptionFlags: word;
  end;

  PCHART_3D = ^TCHART_3D;
  TCHART_3D = packed record
    Rotation   : word;
    Elevation  : word;
    Distance   : word;
    PlotHeight : word;
    Depth      : word;
    Space      : word;
    OptionFlags: word;
  end;

  PCHART_LEGEND = ^TCHART_LEGEND;
  TCHART_LEGEND = packed record
    Top        : cardinal;
    Left       : cardinal;
    Width      : cardinal;
    Height     : cardinal;
    LegendType : byte;
    Spacing    : byte;
    OptionFlags: word;
  end;

  PCHART_OBJECTLINK = ^TCHART_OBJECTLINK;
  TCHART_OBJECTLINK = packed record
    LinkedTo   : word;
    SeriesIndex: word;
    DataIndex  : word;
  end;

  PCHART_SIINDEX = ^TCHART_SIINDEX;
  TCHART_SIINDEX = packed record
    Index: word;
  end;

  PMSO_Header = ^TMSO_Header;
  TMSO_Header = packed record
    Options: word;
    FBT    : word;
    Length : cardinal;
  end;

  TClusterID = packed record
    DgID      : cardinal;
    ShapesUsed: cardinal;
  end;

  PMSO_Dgg = ^TMSO_Dgg;
  TMSO_Dgg = packed record
    MaxShapeID  : cardinal;
    ClusterCount: cardinal;
    ShapesSaved : cardinal;
    DrawingsSaved: cardinal;
    ClusterID: TClusterID;
  end;

  PMSO_Dg = ^TMSO_Dg;
  TMSO_Dg = packed record
    ShapeCount : cardinal;
    CurrShapeID: cardinal;
  end;
  
  PMSO_Sp = ^TMSO_Sp;
  TMSO_Sp = packed record
    ID   : cardinal;
    Flags: cardinal;
  end;

  PMSO_OPT = ^TMSO_OPT;
  TMSO_OPT = packed record
    Options: word;
    Value  : cardinal;
  end;

  PMSO_Anchor = ^TMSO_Anchor;
  TMSO_Anchor = packed record
    Options: word;
    Col1: word;
    Col1Offset: word;
    Row1: word;
    Row1Offset: word;
    Col2: word;
    Col2Offset: word;
    Row2: word;
    Row2Offset: word;
  end;

  PMSO_SplitMenuColors = ^TMSO_SplitMenuColors;
  TMSO_SplitMenuColors = packed record
    TopLevelFill: cardinal;
    LineType    : cardinal;
    Shadow      : cardinal;
    ThreeD      : cardinal;
  end;

  PMSO_BSE = ^TMSO_BSE;
  TMSO_BSE = packed record
    WinType  : byte;
    MacType  : byte;
    Checksum : array[0..15] of byte;
    Tag      : word;
    Size     : cardinal;
    RefCount : cardinal;
    DelOffset: cardinal;
    IsTexture: byte;
    NameLen  : byte;
    Dummy    : word;
  end;

  POBJ_CMO = ^TOBJ_CMO;
  TOBJ_CMO = packed record
    ObjectType : word;
    ObjectID   : word;
    OptionFlags: word;
    Reserved   : array[0..11] of byte;
  end;

  TXLS_FUNCTION = packed record
    Min: byte;
    Max: byte;
    Name: string;
  end;

  TXLS_FUNCTION_ID = (fidCount, fidIf, fidIsNa, fidIsError, fidSum, fidAverage,
    fidMin, fidMax, fidRow, fidColumn, fidNA, fidNPV, fidSTDEV, fidDollar,
    fidFixed, fidSin, fidCos, fidTan, fidATan, fidPI, fidSqrt, fidExp, fidLN,
    fidLog10, fidAbs, fidInt);

  TXLS_FUNCTIONS = array[0..367] of TXLS_FUNCTION;

  TWordBit = (b0, b1, b2, b3, b4, b5, b6, b7, b8, b9, b10, b11, b12, b13, b14, b15);
  TWordBits = set of TWordBit;

const
  XLS_FUNCTIONS: TXLS_FUNCTIONS = (
  {000} (Min: 01; Max: 99; Name: 'COUNT'),
  {001} (Min: 02; Max: 03; Name: 'IF'),
  {002} (Min: 01; Max: 01; Name: 'ISNA'),
  {003} (Min: 01; Max: 01; Name: 'ISERROR'),
  {004} (Min: 01; Max: 99; Name: 'SUM'),
  {005} (Min: 01; Max: 99; Name: 'AVERAGE'),
  {006} (Min: 01; Max: 99; Name: 'MIN'),
  {007} (Min: 01; Max: 99; Name: 'MAX'),
  {008} (Min: 00; Max: 01; Name: 'ROW'),
  {009} (Min: 00; Max: 01; Name: 'COLUMN'),
  {010} (Min: 01; Max: 01; Name: 'NA'),
  {011} (Min: 01; Max: 99; Name: 'NPV'),
  {012} (Min: 01; Max: 99; Name: 'STDEV'),
  {013} (Min: 01; Max: 02; Name: 'DOLLAR'),
  {014} (Min: 01; Max: 03; Name: 'FIXED'),
  {015} (Min: 01; Max: 01; Name: 'SIN'),
  {016} (Min: 01; Max: 01; Name: 'COS'),
  {017} (Min: 01; Max: 01; Name: 'TAN'),
  {018} (Min: 01; Max: 01; Name: 'ATAN'),
  {019} (Min: 00; Max: 00; Name: 'PI'),
  {020} (Min: 01; Max: 01; Name: 'SQRT'),
  {021} (Min: 01; Max: 01; Name: 'EXP'),
  {022} (Min: 01; Max: 01; Name: 'LN'),
  {023} (Min: 01; Max: 01; Name: 'LOG10'),
  {024} (Min: 01; Max: 01; Name: 'ABS'),
  {025} (Min: 01; Max: 01; Name: 'INT'),