| Мельница данных- Создание шаблонов SpreadSheet (раздел целиком) (07.08.2026) | (одним файлом) |
Создание шаблонов SpreadSheet |
1. Справочник по интерфейсам |
1.1. Перечисление TSheetHeaderFooter | |||||||||||||||||||||
1type 2 TSheetHeaderFooter = (shfOddHeader, shfOddFooter, shfEvenHeader, shfEvenFooter, 3 shfFirstHeader, shfFirstFooter); Или 1type 2 TSheetHeaderFooter = TOleEnum; 3const 4 shfOddHeader = $00000000; 5 shfOddFooter = $00000001; 6 shfEvenHeader = $00000002; 7 shfEvenFooter = $00000003; 8 shfFirstHeader = $00000004; 9 shfFirstFooter = $00000005; Элементы перечисления:
|
1.2. Перечисление TSheetHeaderFooterImage | ||||||||||||
1type 2 TSheetHeaderFooterImage = (shfiLeft, shfiCenter, shfiRight); Или 1type 2 TSheetHeaderFooterImage = TOleEnum; 3const 4 shfiLeft = $00000000; 5 shfiCenter = $00000001; 6 shfiRight = $00000002; Элементы перечисления:
|
1.3. Перечисление XlBorderWeight | |||||||||||||||
1type 2 XlBorderWeight = (xlMedium = -4138, xlHairline = 1, xlThin = 2, xlThick = 4); Или 1type 2 XlBorderWeight = TOleEnum; 3const 4 xlMedium = $FFFFEFD6; 5 xlHairline = $00000001; 6 xlThin = $00000002; 7 xlThick = $00000004; Элементы перечисления:
|
1.4. Перечисление XlFormatConditionOperator | |||||||||||||||||||||||||||
1type 2 XlFormatConditionOperator = (xlBetween = 1, xlNotBetween = 2, xlEqual = 3, 3 xlNotEqual = 4, xlGreater = 5, xlLess = 6, xlGreaterEqual = 7, xlLessEqual = 8); Или 01type 02 XlFormatConditionOperator = TOleEnum; 03const 04 xlBetween = $00000001; 05 xlNotBetween = $00000002; 06 xlEqual = $00000003; 07 xlNotEqual = $00000004; 08 xlGreater = $00000005; 09 xlLess = $00000006; 10 xlGreaterEqual = $00000007; 11 xlLessEqual = $00000008; Элементы перечисления:
|
1.5. Перечисление XlFormatConditionType | |||||||||
1type 2 XlFormatConditionType = (xlCellValue = 1, xlExpression = 2); Или 1type 2 XlFormatConditionType = TOleEnum; 3const 4 xlCellValue = $00000001; 5 xlExpression = $00000002; Элементы перечисления:
|
1.6. Перечисление XlHAlign | |||||||||||||||||||||||||||
1type 2 XlHAlign = (xlHAlignRight = -4152, xlHAlignLeft = -4131, xlHAlignJustify = - 3 4130, xlHAlignDistributed = -4117, xlHAlignCenter = -4108, xlHAlignGeneral = 1, 4 xlHAlignFill = 5, xlHAlignCenterAcrossSelection = 7); Или 01type 02 XlHAlign = TOleEnum; 03const 04 xlHAlignRight = $FFFFEFC8; 05 xlHAlignLeft = $FFFFEFDD; 06 xlHAlignJustify = $FFFFEFDE; 07 xlHAlignDistributed = $FFFFEFEB; 08 xlHAlignCenter = $FFFFEFF4; 09 xlHAlignGeneral = $00000001; 10 xlHAlignFill = $00000005; 11 xlHAlignCenterAcrossSelection = $00000007; Элементы перечисления:
|
1.7. Перечисление XlLineStyle | |||||||||||||||||||||||||||
1type 2 XlLineStyle = (xlLineStyleNone = -4142, xlDouble = -4119, xlDot = -4118, 3 xlDash = -4115, xlContinuous = 1, xlDashDot = 4, xlDashDotDot = 5, 4 xlSlantDashDot = 13); Или 01type 02 XlLineStyle = TOleEnum; 03const 04 xlLineStyleNone = $FFFFEFD2; 05 xlDouble = $FFFFEFE9; 06 xlDot = $FFFFEFEA; 07 xlDash = $FFFFEFED; 08 xlContinuous = $00000001; 09 xlDashDot = $00000004; 10 xlDashDotDot = $00000005; 11 xlSlantDashDot = $0000000D; Элементы перечисления:
|
1.8. Перечисление XlOrientation | |||||||||||||||
1type 2 XlOrientation = (xlUpward = -4171, xlDownward = -4170, xlVertical = -4166, 3 xlHorizontal = -4128); Или 1type 2 XlOrientation = TOleEnum; 3const 4 xlUpward = $FFFFEFB5; 5 xlDownward = $FFFFEFB6; 6 xlVertical = $FFFFEFBA; 7 xlHorizontal = $FFFFEFE0; Элементы перечисления:
|
1.9. Перечисление XlPageOrientation | |||||||||
1type 2 XlPageOrientation = (xlPortrait = 1, xlLandscape = 2); Или 1type 2 XlPageOrientation = TOleEnum; 3const 4 xlPortrait = $00000001; 5 xlLandscape = $00000002; Элементы перечисления:
|
1.10. Перечисление XlPaperSize | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
01type 02 XlPaperSize = (xlPaperLetter = 1, xlPaperLetterSmall = 2, xlPaperTabloid = 3, 03 xlPaperLedger = 4, xlPaperLegal = 5, xlPaperStatement = 6, 04 xlPaperExecutive = 7, xlPaperA3 = 8, xlPaperA4 = 9, xlPaperA4Small = 10, 05 xlPaperA5 = 11, xlPaperB4 = 12, xlPaperB5 = 13, xlPaperFolio = 14, 06 xlPaperQuarto = 15, xlPaper10x14 = 16, xlPaper11x17 = 17, xlPaperNote = 18, 07 xlPaperEnvelope9 = 19, xlPaperEnvelope10 = 20, xlPaperEnvelope11 = 21, 08 xlPaperEnvelope12 = 22, xlPaperEnvelope14 = 23, xlPaperCsheet = 24, 09 xlPaperDsheet = 25, xlPaperEsheet = 26, xlPaperEnvelopeDL = 27, 10 xlPaperEnvelopeC5 = 28, xlPaperEnvelopeC3 = 29, xlPaperEnvelopeC4 = 30, 11 xlPaperEnvelopeC6 = 31, xlPaperEnvelopeC65 = 32, xlPaperEnvelopeB4 = 33, 12 xlPaperEnvelopeB5 = 34, xlPaperEnvelopeB6 = 35, xlPaperEnvelopeItaly = 36, 13 xlPaperEnvelopeMonarch = 37, xlPaperEnvelopePersonal = 38, 14 xlPaperFanfoldUS = 39, xlPaperFanfoldStdGerman = 40, 15 xlPaperFanfoldLegalGerman = 41, xlPaperUser = 256); Или 01type 02 XlPaperSize = TOleEnum; 03const 04 xlPaperLetter = $00000001; 05 xlPaperLetterSmall = $00000002; 06 xlPaperTabloid = $00000003; 07 xlPaperLedger = $00000004; 08 xlPaperLegal = $00000005; 09 xlPaperStatement = $00000006; 10 xlPaperExecutive = $00000007; 11 xlPaperA3 = $00000008; 12 xlPaperA4 = $00000009; 13 xlPaperA4Small = $0000000A; 14 xlPaperA5 = $0000000B; 15 xlPaperB4 = $0000000C; 16 xlPaperB5 = $0000000D; 17 xlPaperFolio = $0000000E; 18 xlPaperQuarto = $0000000F; 19 xlPaper10x14 = $00000010; 20 xlPaper11x17 = $00000011; 21 xlPaperNote = $00000012; 22 xlPaperEnvelope9 = $00000013; 23 xlPaperEnvelope10 = $00000014; 24 xlPaperEnvelope11 = $00000015; 25 xlPaperEnvelope12 = $00000016; 26 xlPaperEnvelope14 = $00000017; 27 xlPaperCsheet = $00000018; 28 xlPaperDsheet = $00000019; 29 xlPaperEsheet = $0000001A; 30 xlPaperEnvelopeDL = $0000001B; 31 xlPaperEnvelopeC5 = $0000001C; 32 xlPaperEnvelopeC3 = $0000001D; 33 xlPaperEnvelopeC4 = $0000001E; 34 xlPaperEnvelopeC6 = $0000001F; 35 xlPaperEnvelopeC65 = $00000020; 36 xlPaperEnvelopeB4 = $00000021; 37 xlPaperEnvelopeB5 = $00000022; 38 xlPaperEnvelopeB6 = $00000023; 39 xlPaperEnvelopeItaly = $00000024; 40 xlPaperEnvelopeMonarch = $00000025; 41 xlPaperEnvelopePersonal = $00000026; 42 xlPaperFanfoldUS = $00000027; 43 xlPaperFanfoldStdGerman = $00000028; 44 xlPaperFanfoldLegalGerman = $00000029; 45 xlPaperUser = $00000100; Элементы перечисления:
|
1.11. Перечисление XlPattern | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1type 2 XlPattern = (xlPatternVertical = -4166, xlPatternUp = -4162, xlPatternNone = - 3 4142, xlPatternHorizontal = -4128, xlPatternGray75 = -4126, xlPatternGray50 = - 4 4125, xlPatternGray25 = -4124, xlPatternDown = -4121, xlPatternAutomatic = - 5 4105, xlPatternSolid = 1, xlPatternChecker = 9, xlPatternSemiGray75 = 10, 6 xlPatternLightHorizontal = 11, xlPatternLightVertical = 12, 7 xlPatternLightDown = 13, xlPatternLightUp = 14, xlPatternGrid = 15, 8 xlPatternCrissCross = 16, xlPatternGray16 = 17, xlPatternGray8 = 18); Или 01type 02 XlPattern = TOleEnum; 03const 04 xlPatternVertical = $FFFFEFBA; 05 xlPatternUp = $FFFFEFBE; 06 xlPatternNone = $FFFFEFD2; 07 xlPatternHorizontal = $FFFFEFE0; 08 xlPatternGray75 = $FFFFEFE2; 09 xlPatternGray50 = $FFFFEFE3; 10 xlPatternGray25 = $FFFFEFE4; 11 xlPatternDown = $FFFFEFE7; 12 xlPatternAutomatic = $FFFFEFF7; 13 xlPatternSolid = $00000001; 14 xlPatternChecker = $00000009; 15 xlPatternSemiGray75 = $0000000A; 16 xlPatternLightHorizontal = $0000000B; 17 xlPatternLightVertical = $0000000C; 18 xlPatternLightDown = $0000000D; 19 xlPatternLightUp = $0000000E; 20 xlPatternGrid = $0000000F; 21 xlPatternCrissCross = $00000010; 22 xlPatternGray16 = $00000011; 23 xlPatternGray8 = $00000012; Элементы перечисления:
|
1.12. Перечисление XlReferenceStyle | |||||||||
1type 2 XlReferenceStyle = (xlR1C1 = -4150, xlA1 = 1); Или 1type 2 XlReferenceStyle = TOleEnum; 3const 4 xlR1C1 = $FFFFEFCA; 5 xlA1 = $00000001; Элементы перечисления:
|
1.13. Перечисление XlSheetVisibility | ||||||||||||
1type 2 XlSheetVisibility = (xlSheetVisible = -1, xlSheetHidden = 0, 3 xlSheetVeryHidden = 2); Или 1type 2 XlSheetVisibility = TOleEnum; 3const 4 xlSheetVisible = $FFFFFFFF; 5 xlSheetHidden = $00000000; 6 xlSheetVeryHidden = $00000002; Элементы перечисления:
|
1.14. Перечисление XlSummaryColumn | |||||||||
1type 2 XlSummaryColumn = (xlSummaryOnRight = -4152, xlSummaryOnLeft = -4131); Или 1type 2 XlSummaryColumn = TOleEnum; 3const 4 xlSummaryOnRight = $FFFFEFC8; 5 xlSummaryOnLeft = $FFFFEFDD; Элементы перечисления:
|
1.15. Перечисление XlSummaryRow | |||||||||
1type 2 XlSummaryRow = (xlSummaryAbove, xlSummaryBelow); Или 1type 2 XlSummaryRow = TOleEnum; 3const 4 xlSummaryAbove = $00000000; 5 xlSummaryBelow = $00000001; Элементы перечисления:
|
1.16. Перечисление XlVAlign | ||||||||||||||||||
1type 2 XlVAlign = (xlVAlignTop = -4160, xlVAlignJustify = -4130, 3 xlVAlignDistributed = -4117, xlVAlignCenter = -4108, xlVAlignBottom = -4107); Или 1type 2 XlVAlign = TOleEnum; 3const 4 xlVAlignTop = $FFFFEFC0; 5 xlVAlignJustify = $FFFFEFDE; 6 xlVAlignDistributed = $FFFFEFEB; 7 xlVAlignCenter = $FFFFEFF4; 8 xlVAlignBottom = $FFFFEFF5; Элементы перечисления:
|
1.17. Интерфейс ISheetStyle |
001type 002 ISheetStyle = interface(IDispatch) 003 ['{423CFD04-4A32-469D-8AD6-E9FA41E86414}'] 004 function Get_ApplyBorder: WordBool; safecall; 005 procedure Set_ApplyBorder(Value: WordBool); safecall; 006 function Get_ApplyFill: WordBool; safecall; 007 procedure Set_ApplyFill(Value: WordBool); safecall; 008 function Get_ApplyFont: WordBool; safecall; 009 procedure Set_ApplyFont(Value: WordBool); safecall; 010 function Get_ApplyNumberFormat: WordBool; safecall; 011 procedure Set_ApplyNumberFormat(Value: WordBool); safecall; 012 function Get_NumberFormat: WideString; safecall; 013 procedure Set_NumberFormat(Value: WideString); safecall; 014 function Get_Bold: WordBool; safecall; 015 procedure Set_Bold(Value: WordBool); safecall; 016 function Get_Italic: WordBool; safecall; 017 procedure Set_Italic(Value: WordBool); safecall; 018 function Get_Underline: WordBool; safecall; 019 procedure Set_Underline(Value: WordBool); safecall; 020 function Get_FontColor: OLE_COLOR; safecall; 021 procedure Set_FontColor(Value: OLE_COLOR); safecall; 022 function Get_BackgroundColor: OLE_COLOR; safecall; 023 procedure Set_BackgroundColor(Value: OLE_COLOR); safecall; 024 function Get_Pattern: XlPattern; safecall; 025 procedure Set_Pattern(Value: XlPattern); safecall; 026 function Get_RightBorderStyle: XlLineStyle; safecall; 027 procedure Set_RightBorderStyle(Value: XlLineStyle); safecall; 028 function Get_RightBorderWidth: XlBorderWeight; safecall; 029 procedure Set_RightBorderWidth(Value: XlBorderWeight); safecall; 030 function Get_RightBorderColor: OLE_COLOR; safecall; 031 procedure Set_RightBorderColor(Value: OLE_COLOR); safecall; 032 function Get_BottomBorderStyle: XlLineStyle; safecall; 033 procedure Set_BottomBorderStyle(Value: XlLineStyle); safecall; 034 function Get_BottomBorderWidth: XlBorderWeight; safecall; 035 procedure Set_BottomBorderWidth(Value: XlBorderWeight); safecall; 036 function Get_BottomBorderColor: OLE_COLOR; safecall; 037 procedure Set_BottomBorderColor(Value: OLE_COLOR); safecall; 038 function Get_TopBorderStyle: XlLineStyle; safecall; 039 procedure Set_TopBorderStyle(Value: XlLineStyle); safecall; 040 function Get_TopBorderWidth: XlBorderWeight; safecall; 041 procedure Set_TopBorderWidth(Value: XlBorderWeight); safecall; 042 function Get_TopBorderColor: OLE_COLOR; safecall; 043 procedure Set_TopBorderColor(Value: OLE_COLOR); safecall; 044 function Get_LeftBorderStyle: XlLineStyle; safecall; 045 procedure Set_LeftBorderStyle(Value: XlLineStyle); safecall; 046 function Get_LeftBorderWidth: XlBorderWeight; safecall; 047 procedure Set_LeftBorderWidth(Value: XlBorderWeight); safecall; 048 function Get_LeftBorderColor: OLE_COLOR; safecall; 049 procedure Set_LeftBorderColor(Value: OLE_COLOR); safecall; 050 function Get_DiagonalBorderStyle: XlLineStyle; safecall; 051 procedure Set_DiagonalBorderStyle(Value: XlLineStyle); safecall; 052 function Get_DiagonalBorderWidth: XlBorderWeight; safecall; 053 procedure Set_DiagonalBorderWidth(Value: XlBorderWeight); safecall; 054 function Get_DiagonalBorderColor: OLE_COLOR; safecall; 055 procedure Set_DiagonalBorderColor(Value: OLE_COLOR); safecall; 056 function Get_DiagonalBorderUp: WordBool; safecall; 057 procedure Set_DiagonalBorderUp(Value: WordBool); safecall; 058 function Get_DiagonalBorderDown: WordBool; safecall; 059 procedure Set_DiagonalBorderDown(Value: WordBool); safecall; 060 property ApplyBorder: WordBool read Get_ApplyBorder write Set_ApplyBorder; 061 property ApplyFill: WordBool read Get_ApplyFill write Set_ApplyFill; 062 property ApplyFont: WordBool read Get_ApplyFont write Set_ApplyFont; 063 property ApplyNumberFormat: WordBool read Get_ApplyNumberFormat 064 write Set_ApplyNumberFormat; 065 property NumberFormat: WideString read Get_NumberFormat write Set_NumberFormat; 066 property Bold: WordBool read Get_Bold write Set_Bold; 067 property Italic: WordBool read Get_Italic write Set_Italic; 068 property Underline: WordBool read Get_Underline write Set_Underline; 069 property FontColor: OLE_COLOR read Get_FontColor write Set_FontColor; 070 property BackgroundColor: OLE_COLOR read Get_BackgroundColor 071 write Set_BackgroundColor; 072 property Pattern: XlPattern read Get_Pattern write Set_Pattern; 073 property RightBorderStyle: XlLineStyle read Get_RightBorderStyle 074 write Set_RightBorderStyle; 075 property RightBorderWidth: XlBorderWeight read Get_RightBorderWidth 076 write Set_RightBorderWidth; 077 property RightBorderColor: OLE_COLOR read Get_RightBorderColor 078 write Set_RightBorderColor; 079 property BottomBorderStyle: XlLineStyle read Get_BottomBorderStyle 080 write Set_BottomBorderStyle; 081 property BottomBorderWidth: XlBorderWeight read Get_BottomBorderWidth 082 write Set_BottomBorderWidth; 083 property BottomBorderColor: OLE_COLOR read Get_BottomBorderColor 084 write Set_BottomBorderColor; 085 property TopBorderStyle: XlLineStyle read Get_TopBorderStyle 086 write Set_TopBorderStyle; 087 property TopBorderWidth: XlBorderWeight read Get_TopBorderWidth 088 write Set_TopBorderWidth; 089 property TopBorderColor: OLE_COLOR read Get_TopBorderColor 090 write Set_TopBorderColor; 091 property LeftBorderStyle: XlLineStyle read Get_LeftBorderStyle 092 write Set_LeftBorderStyle; 093 property LeftBorderWidth: XlBorderWeight read Get_LeftBorderWidth 094 write Set_LeftBorderWidth; 095 property LeftBorderColor: OLE_COLOR read Get_LeftBorderColor 096 write Set_LeftBorderColor; 097 property DiagonalBorderStyle: XlLineStyle read Get_DiagonalBorderStyle 098 write Set_DiagonalBorderStyle; 099 property DiagonalBorderWidth: XlBorderWeight read Get_DiagonalBorderWidth 100 write Set_DiagonalBorderWidth; 101 property DiagonalBorderColor: OLE_COLOR read Get_DiagonalBorderColor 102 write Set_DiagonalBorderColor; 103 property DiagonalBorderUp: WordBool read Get_DiagonalBorderUp 104 write Set_DiagonalBorderUp; 105 property DiagonalBorderDown: WordBool read Get_DiagonalBorderDown 106 write Set_DiagonalBorderDown; 107 end; |
1.17.1. Свойства | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Свойства интерфейса ISheetStyle:
|
1.18. Интерфейс ISpreadSheet |
001type 002 ISpreadSheet = interface(IDispatch) 003 ['{0C757D48-CCB4-4482-9094-A2DDE9569B8A}'] 004 function Get_Value(Row: Integer; Col: Integer): OleVariant; safecall; 005 procedure Set_Value(Row: Integer; Col: Integer; Value: OleVariant); safecall; 006 function TryCopyCells(SourceLeft: Integer; SourceTop: Integer; 007 SourceRight: Integer; SourceBottom: Integer; DestinationLeft: Integer; 008 DestinationTop: Integer; DestinationRight: Integer; 009 DestinationBottom: Integer): WordBool; safecall; 010 function Get_FormulasDocument: OleVariant; safecall; 011 function Get_DefaultColWidth: Single; safecall; 012 procedure Set_DefaultColWidth(Value: Single); safecall; 013 function Get_DefaultRowHeight: Single; safecall; 014 procedure Set_DefaultRowHeight(Value: Single); safecall; 015 function Get_DefaultFontName: WideString; safecall; 016 procedure Set_DefaultFontName(Value: WideString); safecall; 017 function Get_DefaultFontSize: Single; safecall; 018 procedure Set_DefaultFontSize(Value: Single); safecall; 019 procedure Touch(Row: Integer; Col: Integer; Used: WordBool); safecall; 020 function Get_Accessible(Row: Integer; Col: Integer): WordBool; safecall; 021 function Get_Text(Row: Integer; Col: Integer): WideString; safecall; 022 function Get_FormulaText(Row: Integer; Col: Integer): WideString; safecall; 023 procedure Set_FormulaText(Row: Integer; Col: Integer; Value: WideString); safecall; 024 function Get_FormulaNode(Row: Integer; Col: Integer): OleVariant; safecall; 025 procedure Set_FormulaNode(Row: Integer; Col: Integer; Value: OleVariant); safecall; 026 function Get_HasFormula(Row: Integer; Col: Integer): WordBool; safecall; 027 function Get_Comment(Row: Integer; Col: Integer): WideString; safecall; 028 procedure Set_Comment(Row: Integer; Col: Integer; Value: WideString); safecall; 029 function Get_NumberFormat(Row: Integer; Col: Integer): WideString; safecall; 030 procedure Set_NumberFormat(Row: Integer; Col: Integer; Value: WideString); safecall; 031 function Get_FontName(Row: Integer; Col: Integer): WideString; safecall; 032 procedure Set_FontName(Row: Integer; Col: Integer; Value: WideString); safecall; 033 function Get_FontSize(Row: Integer; Col: Integer): Single; safecall; 034 procedure Set_FontSize(Row: Integer; Col: Integer; Value: Single); safecall; 035 function Get_Bold(Row: Integer; Col: Integer): WordBool; safecall; 036 procedure Set_Bold(Row: Integer; Col: Integer; Value: WordBool); safecall; 037 function Get_Italic(Row: Integer; Col: Integer): WordBool; safecall; 038 procedure Set_Italic(Row: Integer; Col: Integer; Value: WordBool); safecall; 039 function Get_Underline(Row: Integer; Col: Integer): WordBool; safecall; 040 procedure Set_Underline(Row: Integer; Col: Integer; Value: WordBool); safecall; 041 function Get_FontColor(Row: Integer; Col: Integer): OLE_COLOR; safecall; 042 procedure Set_FontColor(Row: Integer; Col: Integer; Value: OLE_COLOR); safecall; 043 function Get_BackgroundColor(Row: Integer; Col: Integer): OLE_COLOR; safecall; 044 procedure Set_BackgroundColor(Row: Integer; Col: Integer; Value: OLE_COLOR); safecall; 045 function Get_WrapText(Row: Integer; Col: Integer): WordBool; safecall; 046 procedure Set_WrapText(Row: Integer; Col: Integer; Value: WordBool); safecall; 047 function Get_HorizontalAlignment(Row: Integer; Col: Integer): XlHAlign; safecall; 048 procedure Set_HorizontalAlignment(Row: Integer; Col: Integer; Value: XlHAlign); safecall; 049 function Get_VerticalAlignment(Row: Integer; Col: Integer): XlHAlign; safecall; 050 procedure Set_VerticalAlignment(Row: Integer; Col: Integer; Value: XlHAlign); safecall; 051 function Get_IndentLevel(Row: Integer; Col: Integer): Integer; safecall; 052 procedure Set_IndentLevel(Row: Integer; Col: Integer; Value: Integer); safecall; 053 function Get_Locked(Row: Integer; Col: Integer): WordBool; safecall; 054 procedure Set_Locked(Row: Integer; Col: Integer; Value: WordBool); safecall; 055 function Get_Pattern(Row: Integer; Col: Integer): XlPattern; safecall; 056 procedure Set_Pattern(Row: Integer; Col: Integer; Value: XlPattern); safecall; 057 function Get_Orientation(Row: Integer; Col: Integer): XlOrientation; safecall; 058 procedure Set_Orientation(Row: Integer; Col: Integer; Value: XlOrientation); safecall; 059 function Get_RightBorderStyle(Row: Integer; Col: Integer): XlLineStyle; safecall; 060 procedure Set_RightBorderStyle(Row: Integer; Col: Integer; Value: XlLineStyle); safecall; 061 function Get_RightBorderWidth(Row: Integer; Col: Integer): XlBorderWeight; safecall; 062 procedure Set_RightBorderWidth(Row: Integer; Col: Integer; 063 Value: XlBorderWeight); safecall; 064 function Get_RightBorderColor(Row: Integer; Col: Integer): OLE_COLOR; safecall; 065 procedure Set_RightBorderColor(Row: Integer; Col: Integer; Value: OLE_COLOR); safecall; 066 function Get_BottomBorderStyle(Row: Integer; Col: Integer): XlLineStyle; safecall; 067 procedure Set_BottomBorderStyle(Row: Integer; Col: Integer; Value: XlLineStyle); safecall; 068 function Get_BottomBorderWidth(Row: Integer; Col: Integer): XlBorderWeight; safecall; 069 procedure Set_BottomBorderWidth(Row: Integer; Col: Integer; 070 Value: XlBorderWeight); safecall; 071 function Get_BottomBorderColor(Row: Integer; Col: Integer): OLE_COLOR; safecall; 072 procedure Set_BottomBorderColor(Row: Integer; Col: Integer; Value: OLE_COLOR); safecall; 073 function Get_TopBorderStyle(Row: Integer; Col: Integer): XlLineStyle; safecall; 074 procedure Set_TopBorderStyle(Row: Integer; Col: Integer; Value: XlLineStyle); safecall; 075 function Get_TopBorderWidth(Row: Integer; Col: Integer): XlBorderWeight; safecall; 076 procedure Set_TopBorderWidth(Row: Integer; Col: Integer; Value: XlBorderWeight); safecall; 077 function Get_TopBorderColor(Row: Integer; Col: Integer): OLE_COLOR; safecall; 078 procedure Set_TopBorderColor(Row: Integer; Col: Integer; Value: OLE_COLOR); safecall; 079 function Get_LeftBorderStyle(Row: Integer; Col: Integer): XlLineStyle; safecall; 080 procedure Set_LeftBorderStyle(Row: Integer; Col: Integer; Value: XlLineStyle); safecall; 081 function Get_LeftBorderWidth(Row: Integer; Col: Integer): XlBorderWeight; safecall; 082 procedure Set_LeftBorderWidth(Row: Integer; Col: Integer; Value: XlBorderWeight); safecall; 083 function Get_LeftBorderColor(Row: Integer; Col: Integer): OLE_COLOR; safecall; 084 procedure Set_LeftBorderColor(Row: Integer; Col: Integer; Value: OLE_COLOR); safecall; 085 function Get_DiagonalBorderStyle(Row: Integer; Col: Integer): XlLineStyle; safecall; 086 procedure Set_DiagonalBorderStyle(Row: Integer; Col: Integer; 087 Value: XlLineStyle); safecall; 088 function Get_DiagonalBorderWidth(Row: Integer; Col: Integer): XlBorderWeight; safecall; 089 procedure Set_DiagonalBorderWidth(Row: Integer; Col: Integer; 090 Value: XlBorderWeight); safecall; 091 function Get_DiagonalBorderColor(Row: Integer; Col: Integer): OLE_COLOR; safecall; 092 procedure Set_DiagonalBorderColor(Row: Integer; Col: Integer; Value: OLE_COLOR); safecall; 093 function Get_DiagonalBorderUp(Row: Integer; Col: Integer): WordBool; safecall; 094 procedure Set_DiagonalBorderUp(Row: Integer; Col: Integer; Value: WordBool); safecall; 095 function Get_DiagonalBorderDown(Row: Integer; Col: Integer): WordBool; safecall; 096 procedure Set_DiagonalBorderDown(Row: Integer; Col: Integer; Value: WordBool); safecall; 097 function Get_HyperLink(Row: Integer; Col: Integer): WideString; safecall; 098 procedure Set_HyperLink(Row: Integer; Col: Integer; Value: WideString); safecall; 099 function Get_ColCount: Integer; safecall; 100 function Get_RowCount: Integer; safecall; 101 function Get_Width(Col: Integer): Single; safecall; 102 procedure Set_Width(Col: Integer; Value: Single); safecall; 103 function Get_ColWidth(Col: Integer): Single; safecall; 104 procedure Set_ColWidth(Col: Integer; Value: Single); safecall; 105 function Get_ColHasPageBreak(Col: Integer): WordBool; safecall; 106 procedure Set_ColHasPageBreak(Col: Integer; Value: WordBool); safecall; 107 function Get_Height(Row: Integer): Single; safecall; 108 procedure Set_Height(Row: Integer; Value: Single); safecall; 109 function Get_RowHeight(Row: Integer): Single; safecall; 110 procedure Set_RowHeight(Row: Integer; Value: Single); safecall; 111 function Get_RowHasPageBreak(Row: Integer): WordBool; safecall; 112 procedure Set_RowHasPageBreak(Row: Integer; Value: WordBool); safecall; 113 procedure InsertRow(ARow: Integer; RowCount: Integer); safecall; 114 procedure DeleteRow(ARow: Integer; RowCount: Integer); safecall; 115 procedure InsertCol(ACol: Integer; ColCount: Integer); safecall; 116 procedure DeleteCol(ACol: Integer; ColCount: Integer); safecall; 117 function GetMergeInfo(Row: Integer; Col: Integer; out Left: Integer; 118 out Top: Integer; out Right: Integer; out Bottom: Integer): WordBool; safecall; 119 function TryMergeCells(Left: Integer; Top: Integer; Right: Integer; 120 Bottom: Integer): WordBool; safecall; 121 procedure UnMergeCells(Left: Integer; Top: Integer; Right: Integer; 122 Bottom: Integer); safecall; 123 function Get_SheetName: WideString; safecall; 124 procedure Set_SheetName(Value: WideString); safecall; 125 function Get_SheetVisible: XlSheetVisibility; safecall; 126 procedure Set_SheetVisible(Value: XlSheetVisibility); safecall; 127 function Get_SheetOrientation: XlPageOrientation; safecall; 128 procedure Set_SheetOrientation(Value: XlPageOrientation); safecall; 129 function Get_SheetPaperSize: XlPaperSize; safecall; 130 procedure Set_SheetPaperSize(Value: XlPaperSize); safecall; 131 function Get_SheetBlackAndWhite: WordBool; safecall; 132 procedure Set_SheetBlackAndWhite(Value: WordBool); safecall; 133 function Get_SheetZoom: Integer; safecall; 134 procedure Set_SheetZoom(Value: Integer); safecall; 135 function Get_SheetFitPage: WordBool; safecall; 136 procedure Set_SheetFitPage(Value: WordBool); safecall; 137 function Get_SheetFitPageWidth: Integer; safecall; 138 procedure Set_SheetFitPageWidth(Value: Integer); safecall; 139 function Get_SheetFitPageHeight: Integer; safecall; 140 procedure Set_SheetFitPageHeight(Value: Integer); safecall; 141 function Get_SheetLeftMargin: Single; safecall; 142 procedure Set_SheetLeftMargin(Value: Single); safecall; 143 function Get_SheetTopMargin: Single; safecall; 144 procedure Set_SheetTopMargin(Value: Single); safecall; 145 function Get_SheetRightMargin: Single; safecall; 146 procedure Set_SheetRightMargin(Value: Single); safecall; 147 function Get_SheetBottomMargin: Single; safecall; 148 procedure Set_SheetBottomMargin(Value: Single); safecall; 149 function Get_SheetHeaderMargin: Single; safecall; 150 procedure Set_SheetHeaderMargin(Value: Single); safecall; 151 function Get_SheetFooterMargin: Single; safecall; 152 procedure Set_SheetFooterMargin(Value: Single); safecall; 153 function Get_SheetHorizontalCenter: WordBool; safecall; 154 procedure Set_SheetHorizontalCenter(Value: WordBool); safecall; 155 function Get_SheetVerticalCenter: WordBool; safecall; 156 procedure Set_SheetVerticalCenter(Value: WordBool); safecall; 157 function Get_SheetHeaderFooterAlignWithMargins: WordBool; safecall; 158 procedure Set_SheetHeaderFooterAlignWithMargins(Value: WordBool); safecall; 159 function Get_SheetHeaderFooterScaleWithDoc: WordBool; safecall; 160 procedure Set_SheetHeaderFooterScaleWithDoc(Value: WordBool); safecall; 161 function Get_SheetHeaderFooterHasFirst: WordBool; safecall; 162 procedure Set_SheetHeaderFooterHasFirst(Value: WordBool); safecall; 163 function Get_SheetHeaderFooterHasEven: WordBool; safecall; 164 procedure Set_SheetHeaderFooterHasEven(Value: WordBool); safecall; 165 function Get_SheetHeaderFooter(Index: TSheetHeaderFooter): WideString; safecall; 166 procedure Set_SheetHeaderFooter(Index: TSheetHeaderFooter; Value: WideString); safecall; 167 function HasSheetHeaderFooterImage: WordBool; safecall; 168 procedure SetSheetHeaderFooterImage(Index: TSheetHeaderFooter; 169 Image: TSheetHeaderFooterImage; Width: Single; Height: Single; Data: OleVariant); safecall; 170 function GetSheetHeaderFooterImage(Index: TSheetHeaderFooter; 171 Image: TSheetHeaderFooterImage; out Width: Single; out Height: Single; 172 out Data: OleVariant): WordBool; safecall; 173 function Get_FixedCols: Integer; safecall; 174 procedure Set_FixedCols(Value: Integer); safecall; 175 function Get_FixedRows: Integer; safecall; 176 procedure Set_FixedRows(Value: Integer); safecall; 177 function Get_Zoom: Integer; safecall; 178 procedure Set_Zoom(Value: Integer); safecall; 179 function Get_TabColor: OLE_COLOR; safecall; 180 procedure Set_TabColor(Value: OLE_COLOR); safecall; 181 function NamesCount: Integer; safecall; 182 function AddName(const Name: WideString; Left: Integer; Top: Integer; 183 Right: Integer; Bottom: Integer; AdditionalTile: WordBool; 184 Local: WordBool): Integer; safecall; 185 function FindName(const Name: WideString; out Index: Integer; 186 out Local: WordBool): WordBool; safecall; 187 procedure GetNameInfo(Index: Integer; out TileCount: Integer; 188 out Name: WideString; out Local: WordBool); safecall; 189 procedure GetNameTileInfo(Index: Integer; TileIndex: Integer; 190 out Left: Integer; out Top: Integer; out Right: Integer; out Bottom: Integer); safecall; 191 procedure DeleteName(Index: Integer); safecall; 192 function FormatConditionsCount: Integer; safecall; 193 function AddFormatCondition(Left: Integer; Top: Integer; Right: Integer; 194 Bottom: Integer; Priority: Integer; StopIfTrue: WordBool; 195 FormatConditionType: XlFormatConditionType; 196 FormatConditionOperator: XlFormatConditionOperator; Formula1Node: OleVariant; 197 const Formula1Text: WideString; Formula2Node: OleVariant; 198 const Formula2Text: WideString; Style: ISheetStyle): Integer; safecall; 199 procedure GetFormatConditionInfo(Index: Integer; out Left: Integer; 200 out Top: Integer; out Right: Integer; out Bottom: Integer; 201 out Priority: Integer; out StopIfTrue: WordBool; 202 out FormatConditionType: XlFormatConditionType; 203 out FormatConditionOperator: XlFormatConditionOperator; 204 out Formula1Node: OleVariant; out Formula1Text: WideString; 205 out Formula2Node: OleVariant; out Formula2Text: WideString; 206 out Style: ISheetStyle); safecall; 207 procedure DeleteFormatCondition(Index: Integer); safecall; 208 procedure SortFormatConditions; safecall; 209 function ImagesCount: Integer; safecall; 210 function AddImage(Row: Integer; Col: Integer; Left: Single; Top: Single; 211 Width: Single; Height: Single; Data: OleVariant): Integer; safecall; 212 procedure GetImageInfo(Index: Integer; Row: Integer; Col: Integer; 213 out Left: Single; out Top: Single; out Width: Integer; out Height: Integer; 214 out Data: OleVariant); safecall; 215 procedure DeleteImage(Index: Integer); safecall; 216 function Get_BackgroundImage: OleVariant; safecall; 217 procedure Set_BackgroundImage(Value: OleVariant); safecall; 218 procedure AutoFit(Left: Integer; Top: Integer; Right: Integer; Bottom: Integer); safecall; 219 procedure CropUsedRange; safecall; 220 procedure Calculate; safecall; 221 procedure ParseAllFormulas; safecall; 222 function Evaluate(FormulaNode: OleVariant; const FormulaText: WideString; 223 Row: Integer; Col: Integer): OleVariant; safecall; 224 function Get_SummaryCol: XlSummaryColumn; safecall; 225 procedure Set_SummaryCol(Value: XlSummaryColumn); safecall; 226 function Get_SummaryRow: XlSummaryRow; safecall; 227 procedure Set_SummaryRow(Value: XlSummaryRow); safecall; 228 function Get_ColOutline(Col: Integer): Integer; safecall; 229 procedure Set_ColOutline(Col: Integer; Value: Integer); safecall; 230 function Get_ColCollapsed(Col: Integer): WordBool; safecall; 231 procedure Set_ColCollapsed(Col: Integer; Value: WordBool); safecall; 232 function Get_RowOutline(Row: Integer): Integer; safecall; 233 procedure Set_RowOutline(Row: Integer; Value: Integer); safecall; 234 function Get_RowCollapsed(Row: Integer): WordBool; safecall; 235 procedure Set_RowCollapsed(Row: Integer; Value: WordBool); safecall; 236 function Get_ShrinkToFit(Row: Integer; Col: Integer): WordBool; safecall; 237 procedure Set_ShrinkToFit(Row: Integer; Col: Integer; Value: WordBool); safecall; 238 function Get_ReferenceStyle: XlReferenceStyle; safecall; 239 procedure Set_ReferenceStyle(Value: XlReferenceStyle); safecall; 240 property Value[Row: Integer; Col: Integer]: OleVariant read Get_Value 241 write Set_Value; 242 property FormulasDocument: OleVariant read Get_FormulasDocument; 243 property DefaultColWidth: Single read Get_DefaultColWidth 244 write Set_DefaultColWidth; 245 property DefaultRowHeight: Single read Get_DefaultRowHeight 246 write Set_DefaultRowHeight; 247 property DefaultFontName: WideString read Get_DefaultFontName 248 write Set_DefaultFontName; 249 property DefaultFontSize: Single read Get_DefaultFontSize 250 write Set_DefaultFontSize; 251 property Accessible[Row: Integer; Col: Integer]: WordBool read Get_Accessible; 252 property Text[Row: Integer; Col: Integer]: WideString read Get_Text; 253 property FormulaText[Row: Integer; Col: Integer]: WideString 254 read Get_FormulaText write Set_FormulaText; 255 property FormulaNode[Row: Integer; Col: Integer]: OleVariant 256 read Get_FormulaNode write Set_FormulaNode; 257 property HasFormula[Row: Integer; Col: Integer]: WordBool read Get_HasFormula; 258 property Comment[Row: Integer; Col: Integer]: WideString read Get_Comment 259 write Set_Comment; 260 property NumberFormat[Row: Integer; Col: Integer]: WideString 261 read Get_NumberFormat write Set_NumberFormat; 262 property FontName[Row: Integer; Col: Integer]: WideString read Get_FontName 263 write Set_FontName; 264 property FontSize[Row: Integer; Col: Integer]: Single read Get_FontSize 265 write Set_FontSize; 266 property Bold[Row: Integer; Col: Integer]: WordBool read Get_Bold write Set_Bold; 267 property Italic[Row: Integer; Col: Integer]: WordBool read Get_Italic 268 write Set_Italic; 269 property Underline[Row: Integer; Col: Integer]: WordBool read Get_Underline 270 write Set_Underline; 271 property FontColor[Row: Integer; Col: Integer]: OLE_COLOR read Get_FontColor 272 write Set_FontColor; 273 property BackgroundColor[Row: Integer; Col: Integer]: OLE_COLOR 274 read Get_BackgroundColor write Set_BackgroundColor; 275 property WrapText[Row: Integer; Col: Integer]: WordBool read Get_WrapText 276 write Set_WrapText; 277 property HorizontalAlignment[Row: Integer; Col: Integer]: XlHAlign 278 read Get_HorizontalAlignment write Set_HorizontalAlignment; 279 property VerticalAlignment[Row: Integer; Col: Integer]: XlHAlign 280 read Get_VerticalAlignment write Set_VerticalAlignment; 281 property IndentLevel[Row: Integer; Col: Integer]: Integer read Get_IndentLevel 282 write Set_IndentLevel; 283 property Locked[Row: Integer; Col: Integer]: WordBool read Get_Locked 284 write Set_Locked; 285 property Pattern[Row: Integer; Col: Integer]: XlPattern read Get_Pattern 286 write Set_Pattern; 287 property Orientation[Row: Integer; Col: Integer]: XlOrientation 288 read Get_Orientation write Set_Orientation; 289 property RightBorderStyle[Row: Integer; Col: Integer]: XlLineStyle 290 read Get_RightBorderStyle write Set_RightBorderStyle; 291 property RightBorderWidth[Row: Integer; Col: Integer]: XlBorderWeight 292 read Get_RightBorderWidth write Set_RightBorderWidth; 293 property RightBorderColor[Row: Integer; Col: Integer]: OLE_COLOR 294 read Get_RightBorderColor write Set_RightBorderColor; 295 property BottomBorderStyle[Row: Integer; Col: Integer]: XlLineStyle 296 read Get_BottomBorderStyle write Set_BottomBorderStyle; 297 property BottomBorderWidth[Row: Integer; Col: Integer]: XlBorderWeight 298 read Get_BottomBorderWidth write Set_BottomBorderWidth; 299 property BottomBorderColor[Row: Integer; Col: Integer]: OLE_COLOR 300 read Get_BottomBorderColor write Set_BottomBorderColor; 301 property TopBorderStyle[Row: Integer; Col: Integer]: XlLineStyle 302 read Get_TopBorderStyle write Set_TopBorderStyle; 303 property TopBorderWidth[Row: Integer; Col: Integer]: XlBorderWeight 304 read Get_TopBorderWidth write Set_TopBorderWidth; 305 property TopBorderColor[Row: Integer; Col: Integer]: OLE_COLOR 306 read Get_TopBorderColor write Set_TopBorderColor; 307 property LeftBorderStyle[Row: Integer; Col: Integer]: XlLineStyle 308 read Get_LeftBorderStyle write Set_LeftBorderStyle; 309 property LeftBorderWidth[Row: Integer; Col: Integer]: XlBorderWeight 310 read Get_LeftBorderWidth write Set_LeftBorderWidth; 311 property LeftBorderColor[Row: Integer; Col: Integer]: OLE_COLOR 312 read Get_LeftBorderColor write Set_LeftBorderColor; 313 property DiagonalBorderStyle[Row: Integer; Col: Integer]: XlLineStyle 314 read Get_DiagonalBorderStyle write Set_DiagonalBorderStyle; 315 property DiagonalBorderWidth[Row: Integer; Col: Integer]: XlBorderWeight 316 read Get_DiagonalBorderWidth write Set_DiagonalBorderWidth; 317 property DiagonalBorderColor[Row: Integer; Col: Integer]: OLE_COLOR 318 read Get_DiagonalBorderColor write Set_DiagonalBorderColor; 319 property DiagonalBorderUp[Row: Integer; Col: Integer]: WordBool 320 read Get_DiagonalBorderUp write Set_DiagonalBorderUp; 321 property DiagonalBorderDown[Row: Integer; Col: Integer]: WordBool 322 read Get_DiagonalBorderDown write Set_DiagonalBorderDown; 323 property HyperLink[Row: Integer; Col: Integer]: WideString read Get_HyperLink 324 write Set_HyperLink; 325 property ColCount: Integer read Get_ColCount; 326 property RowCount: Integer read Get_RowCount; 327 property Width[Col: Integer]: Single read Get_Width write Set_Width; 328 property ColWidth[Col: Integer]: Single read Get_ColWidth write Set_ColWidth; 329 property ColHasPageBreak[Col: Integer]: WordBool read Get_ColHasPageBreak 330 write Set_ColHasPageBreak; 331 property Height[Row: Integer]: Single read Get_Height write Set_Height; 332 property RowHeight[Row: Integer]: Single read Get_RowHeight write Set_RowHeight; 333 property RowHasPageBreak[Row: Integer]: WordBool read Get_RowHasPageBreak 334 write Set_RowHasPageBreak; 335 property SheetName: WideString read Get_SheetName write Set_SheetName; 336 property SheetVisible: XlSheetVisibility read Get_SheetVisible 337 write Set_SheetVisible; 338 property SheetOrientation: XlPageOrientation read Get_SheetOrientation 339 write Set_SheetOrientation; 340 property SheetPaperSize: XlPaperSize read Get_SheetPaperSize 341 write Set_SheetPaperSize; 342 property SheetBlackAndWhite: WordBool read Get_SheetBlackAndWhite 343 write Set_SheetBlackAndWhite; 344 property SheetZoom: Integer read Get_SheetZoom write Set_SheetZoom; 345 property SheetFitPage: WordBool read Get_SheetFitPage write Set_SheetFitPage; 346 property SheetFitPageWidth: Integer read Get_SheetFitPageWidth 347 write Set_SheetFitPageWidth; 348 property SheetFitPageHeight: Integer read Get_SheetFitPageHeight 349 write Set_SheetFitPageHeight; 350 property SheetLeftMargin: Single read Get_SheetLeftMargin 351 write Set_SheetLeftMargin; 352 property SheetTopMargin: Single read Get_SheetTopMargin write Set_SheetTopMargin; 353 property SheetRightMargin: Single read Get_SheetRightMargin 354 write Set_SheetRightMargin; 355 property SheetBottomMargin: Single read Get_SheetBottomMargin 356 write Set_SheetBottomMargin; 357 property SheetHeaderMargin: Single read Get_SheetHeaderMargin 358 write Set_SheetHeaderMargin; 359 property SheetFooterMargin: Single read Get_SheetFooterMargin 360 write Set_SheetFooterMargin; 361 property SheetHorizontalCenter: WordBool read Get_SheetHorizontalCenter 362 write Set_SheetHorizontalCenter; 363 property SheetVerticalCenter: WordBool read Get_SheetVerticalCenter 364 write Set_SheetVerticalCenter; 365 property SheetHeaderFooterAlignWithMargins: WordBool 366 read Get_SheetHeaderFooterAlignWithMargins 367 write Set_SheetHeaderFooterAlignWithMargins; 368 property SheetHeaderFooterScaleWithDoc: WordBool 369 read Get_SheetHeaderFooterScaleWithDoc write Set_SheetHeaderFooterScaleWithDoc; 370 property SheetHeaderFooterHasFirst: WordBool read Get_SheetHeaderFooterHasFirst 371 write Set_SheetHeaderFooterHasFirst; 372 property SheetHeaderFooterHasEven: WordBool read Get_SheetHeaderFooterHasEven 373 write Set_SheetHeaderFooterHasEven; 374 property SheetHeaderFooter[Index: TSheetHeaderFooter]: WideString 375 read Get_SheetHeaderFooter write Set_SheetHeaderFooter; 376 property FixedCols: Integer read Get_FixedCols write Set_FixedCols; 377 property FixedRows: Integer read Get_FixedRows write Set_FixedRows; 378 property Zoom: Integer read Get_Zoom write Set_Zoom; 379 property TabColor: OLE_COLOR read Get_TabColor write Set_TabColor; 380 property BackgroundImage: OleVariant read Get_BackgroundImage 381 write Set_BackgroundImage; 382 property SummaryCol: XlSummaryColumn read Get_SummaryCol write Set_SummaryCol; 383 property SummaryRow: XlSummaryRow read Get_SummaryRow write Set_SummaryRow; 384 property ColOutline[Col: Integer]: Integer read Get_ColOutline 385 write Set_ColOutline; 386 property ColCollapsed[Col: Integer]: WordBool read Get_ColCollapsed 387 write Set_ColCollapsed; 388 property RowOutline[Row: Integer]: Integer read Get_RowOutline 389 write Set_RowOutline; 390 property RowCollapsed[Row: Integer]: WordBool read Get_RowCollapsed 391 write Set_RowCollapsed; 392 property ShrinkToFit[Row: Integer; Col: Integer]: WordBool read Get_ShrinkToFit 393 write Set_ShrinkToFit; 394 property ReferenceStyle: XlReferenceStyle read Get_ReferenceStyle 395 write Set_ReferenceStyle; 396 end; |
1.18.1. Свойства | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Свойства интерфейса ISpreadSheet:
|
1.18.2. Метод AddFormatCondition | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1function ISpreadSheet.AddFormatCondition(Left: Integer; Top: Integer; 2 Right: Integer; Bottom: Integer; Priority: Integer; StopIfTrue: WordBool; 3 FormatConditionType: XlFormatConditionType; 4 FormatConditionOperator: XlFormatConditionOperator; Formula1Node: OleVariant; 5 const Formula1Text: WideString; Formula2Node: OleVariant; 6 const Formula2Text: WideString; Style: ISheetStyle): Integer; Параметры:
Замечания: Возвращает значение типа Integer. |
1.18.3. Метод AddImage | ||||||||||||||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1function ISpreadSheet.AddImage(Row: Integer; Col: Integer; Left: Single; 2 Top: Single; Width: Single; Height: Single; Data: OleVariant): Integer; Параметры:
Замечания: Возвращает значение типа Integer. |
1.18.4. Метод AddName | ||||||||||||||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1function ISpreadSheet.AddName(const Name: WideString; Left: Integer; 2 Top: Integer; Right: Integer; Bottom: Integer; AdditionalTile: WordBool; 3 Local: WordBool): Integer; Параметры:
Замечания: Возвращает значение типа Integer. |
1.18.5. Метод AutoFit | ||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1procedure ISpreadSheet.AutoFit(Left: Integer; Top: Integer; Right: Integer; 2 Bottom: Integer); Параметры:
|
1.18.6. Метод Calculate |
1.18.7. Метод CropUsedRange |
1.18.8. Метод DeleteCol | ||||||||||||
Метод интерфейса ISpreadSheet. procedure ISpreadSheet.DeleteCol(ACol: Integer; ColCount: Integer); Параметры:
|
1.18.9. Метод DeleteFormatCondition | ||||||||
Метод интерфейса ISpreadSheet. procedure ISpreadSheet.DeleteFormatCondition(Index: Integer); Параметры:
|
1.18.10. Метод DeleteImage | ||||||||
Метод интерфейса ISpreadSheet. procedure ISpreadSheet.DeleteImage(Index: Integer); Параметры:
|
1.18.11. Метод DeleteName | ||||||||
Метод интерфейса ISpreadSheet. procedure ISpreadSheet.DeleteName(Index: Integer); Параметры:
|
1.18.12. Метод DeleteRow | ||||||||||||
Метод интерфейса ISpreadSheet. procedure ISpreadSheet.DeleteRow(ARow: Integer; RowCount: Integer); Параметры:
|
1.18.13. Метод Evaluate | ||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1function ISpreadSheet.Evaluate(FormulaNode: OleVariant; 2 const FormulaText: WideString; Row: Integer; Col: Integer): OleVariant; Параметры:
Замечания: Возвращает значение типа OleVariant. |
1.18.14. Метод FindName | ||||||||||||||||
Метод интерфейса ISpreadSheet. 1function ISpreadSheet.FindName(const Name: WideString; out Index: Integer; 2 out Local: WordBool): WordBool; Параметры:
Замечания: Возвращает значение типа WordBool. |
1.18.15. Метод FormatConditionsCount |
Метод интерфейса ISpreadSheet. function ISpreadSheet.FormatConditionsCount: Integer; Метод не имеет параметров. Замечания: Возвращает значение типа Integer. |
1.18.16. Метод GetFormatConditionInfo | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1procedure ISpreadSheet.GetFormatConditionInfo(Index: Integer; 2 out Left: Integer; out Top: Integer; out Right: Integer; out Bottom: Integer; 3 out Priority: Integer; out StopIfTrue: WordBool; 4 out FormatConditionType: XlFormatConditionType; 5 out FormatConditionOperator: XlFormatConditionOperator; 6 out Formula1Node: OleVariant; out Formula1Text: WideString; 7 out Formula2Node: OleVariant; out Formula2Text: WideString; 8 out Style: ISheetStyle); Параметры:
|
1.18.17. Метод GetImageInfo | ||||||||||||||||||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1procedure ISpreadSheet.GetImageInfo(Index: Integer; Row: Integer; Col: Integer; 2 out Left: Single; out Top: Single; out Width: Integer; out Height: Integer; 3 out Data: OleVariant); Параметры:
|
1.18.18. Метод GetMergeInfo | ||||||||||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1function ISpreadSheet.GetMergeInfo(Row: Integer; Col: Integer; 2 out Left: Integer; out Top: Integer; out Right: Integer; 3 out Bottom: Integer): WordBool; Параметры:
Замечания: Возвращает значение типа WordBool. |
1.18.19. Метод GetNameInfo | ||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1procedure ISpreadSheet.GetNameInfo(Index: Integer; out TileCount: Integer; 2 out Name: WideString; out Local: WordBool); Параметры:
|
1.18.20. Метод GetNameTileInfo | ||||||||||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1procedure ISpreadSheet.GetNameTileInfo(Index: Integer; TileIndex: Integer; 2 out Left: Integer; out Top: Integer; out Right: Integer; out Bottom: Integer); Параметры:
|
1.18.21. Метод GetSheetHeaderFooterImage | ||||||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1function ISpreadSheet.GetSheetHeaderFooterImage(Index: TSheetHeaderFooter; 2 Image: TSheetHeaderFooterImage; out Width: Single; out Height: Single; 3 out Data: OleVariant): WordBool; Параметры:
Замечания: Возвращает значение типа WordBool. |
1.18.22. Метод HasSheetHeaderFooterImage |
Метод интерфейса ISpreadSheet. function ISpreadSheet.HasSheetHeaderFooterImage: WordBool; Метод не имеет параметров. Замечания: Возвращает значение типа WordBool. |
1.18.23. Метод ImagesCount |
Метод интерфейса ISpreadSheet. function ISpreadSheet.ImagesCount: Integer; Метод не имеет параметров. Замечания: Возвращает значение типа Integer. |
1.18.24. Метод InsertCol | ||||||||||||
Метод интерфейса ISpreadSheet. procedure ISpreadSheet.InsertCol(ACol: Integer; ColCount: Integer); Параметры:
|
1.18.25. Метод InsertRow | ||||||||||||
Метод интерфейса ISpreadSheet. procedure ISpreadSheet.InsertRow(ARow: Integer; RowCount: Integer); Параметры:
|
1.18.26. Метод NamesCount |
Метод интерфейса ISpreadSheet. function ISpreadSheet.NamesCount: Integer; Метод не имеет параметров. Замечания: Возвращает значение типа Integer. |
1.18.27. Метод ParseAllFormulas |
1.18.28. Метод SetSheetHeaderFooterImage | ||||||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1procedure ISpreadSheet.SetSheetHeaderFooterImage(Index: TSheetHeaderFooter; 2 Image: TSheetHeaderFooterImage; Width: Single; Height: Single; Data: OleVariant); Параметры:
|
1.18.29. Метод SortFormatConditions |
Метод интерфейса ISpreadSheet. procedure ISpreadSheet.SortFormatConditions; Метод не имеет параметров. |
1.18.30. Метод Touch | ||||||||||||||||
Метод интерфейса ISpreadSheet. procedure ISpreadSheet.Touch(Row: Integer; Col: Integer; Used: WordBool); Параметры:
|
1.18.31. Метод TryCopyCells | ||||||||||||||||||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1function ISpreadSheet.TryCopyCells(SourceLeft: Integer; SourceTop: Integer; 2 SourceRight: Integer; SourceBottom: Integer; DestinationLeft: Integer; 3 DestinationTop: Integer; DestinationRight: Integer; 4 DestinationBottom: Integer): WordBool; Параметры:
Замечания: Возвращает значение типа WordBool. |
1.18.32. Метод TryMergeCells | ||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1function ISpreadSheet.TryMergeCells(Left: Integer; Top: Integer; 2 Right: Integer; Bottom: Integer): WordBool; Параметры:
Замечания: Возвращает значение типа WordBool. |
1.18.33. Метод UnMergeCells | ||||||||||||||||||||
Метод интерфейса ISpreadSheet. 1procedure ISpreadSheet.UnMergeCells(Left: Integer; Top: Integer; 2 Right: Integer; Bottom: Integer); Параметры:
|
1.19. Интерфейс IWorkBook |
01type 02 IWorkBook = interface(IDispatch) 03 ['{A645DB60-CE9A-45E3-A948-B668AB210D36}'] 04 function Get_WorkSheetNameTemplate: WideString; safecall; 05 procedure Set_WorkSheetNameTemplate(Value: WideString); safecall; 06 function AddWorkSheet(Sample: ISpreadSheet): ISpreadSheet; safecall; 07 procedure RemoveWorkSheet(WorkSheet: ISpreadSheet); safecall; 08 function SheetIndex(Sheet: ISpreadSheet): Integer; safecall; 09 procedure SetSheetIndex(Sheet: ISpreadSheet; Index: Integer); safecall; 10 function Get_WorkSheetCount: Integer; safecall; 11 function WorkSheets(Index: Integer): ISpreadSheet; safecall; 12 function Get_FileName: WideString; safecall; 13 procedure Set_FileName(Value: WideString); safecall; 14 function Get_ActiveSheet: ISpreadSheet; safecall; 15 procedure Set_ActiveSheet(Value: ISpreadSheet); safecall; 16 function Get_DefaultFontName: WideString; safecall; 17 procedure Set_DefaultFontName(Value: WideString); safecall; 18 function Get_DefaultFontSize: Single; safecall; 19 procedure Set_DefaultFontSize(Value: Single); safecall; 20 function Get_MacroEnabled: WordBool; safecall; 21 procedure Set_MacroEnabled(Value: WordBool); safecall; 22 function Get_IsTemplate: WordBool; safecall; 23 procedure Set_IsTemplate(Value: WordBool); safecall; 24 function Get_ReferenceStyle: XlReferenceStyle; safecall; 25 procedure Set_ReferenceStyle(Value: XlReferenceStyle); safecall; 26 property WorkSheetNameTemplate: WideString read Get_WorkSheetNameTemplate 27 write Set_WorkSheetNameTemplate; 28 property WorkSheetCount: Integer read Get_WorkSheetCount; 29 property FileName: WideString read Get_FileName write Set_FileName; 30 property ActiveSheet: ISpreadSheet read Get_ActiveSheet write Set_ActiveSheet; 31 property DefaultFontName: WideString read Get_DefaultFontName 32 write Set_DefaultFontName; 33 property DefaultFontSize: Single read Get_DefaultFontSize 34 write Set_DefaultFontSize; 35 property MacroEnabled: WordBool read Get_MacroEnabled write Set_MacroEnabled; 36 property IsTemplate: WordBool read Get_IsTemplate write Set_IsTemplate; 37 property ReferenceStyle: XlReferenceStyle read Get_ReferenceStyle 38 write Set_ReferenceStyle; 39 end; |
1.19.1. Свойства | ||||||||||||||||||||||||||||||||||||||||
Свойства интерфейса IWorkBook:
|
1.19.2. Метод AddWorkSheet | ||||||||
Метод интерфейса IWorkBook. function IWorkBook.AddWorkSheet(Sample: ISpreadSheet): ISpreadSheet; Параметры:
Замечания: Возвращает значение типа ISpreadSheet. |
1.19.3. Метод RemoveWorkSheet | ||||||||
Метод интерфейса IWorkBook. procedure IWorkBook.RemoveWorkSheet(WorkSheet: ISpreadSheet); Параметры:
|
1.19.4. Метод SetSheetIndex | ||||||||||||
Метод интерфейса IWorkBook. procedure IWorkBook.SetSheetIndex(Sheet: ISpreadSheet; Index: Integer); Параметры:
|
1.19.5. Метод SheetIndex | ||||||||
Метод интерфейса IWorkBook. function IWorkBook.SheetIndex(Sheet: ISpreadSheet): Integer; Параметры:
Замечания: Возвращает значение типа Integer. |
1.19.6. Метод WorkSheets | ||||||||
Метод интерфейса IWorkBook. function IWorkBook.WorkSheets(Index: Integer): ISpreadSheet; Параметры:
Замечания: Возвращает значение типа ISpreadSheet. |
1.20. Интерфейс IWorkBooks |
01type 02 IWorkBooks = interface(IDispatch) 03 ['{0ED2C94A-2D25-4AC1-86FB-F69A6A034547}'] 04 function AddWorkBook(WorkBook: IWorkBook): IWorkBook; safecall; 05 procedure RemoveWorkBook(WorkBook: IWorkBook); safecall; 06 function Get_WorkBookCount: Integer; safecall; 07 function Get_WorkBooks(Index: Integer): IWorkBook; safecall; 08 function Get_ActiveBook: IWorkBook; safecall; 09 procedure Set_ActiveBook(Value: IWorkBook); safecall; 10 procedure CreateStyle(ApplyNumberFormat: WordBool; 11 const NumberFormat: WideString; ApplyFont: WordBool; Bold: WordBool; 12 Italic: WordBool; Underline: WordBool; FontColor: OLE_COLOR; 13 ApplyFill: WordBool; BackgroundColor: OLE_COLOR; Pattern: XlPattern; 14 ApplyBorder: WordBool; LeftBorderStyle: XlLineStyle; 15 LeftBorderWidth: XlBorderWeight; LeftBorderColor: OLE_COLOR; 16 TopBorderStyle: XlLineStyle; TopBorderWidth: XlBorderWeight; 17 TopBorderColor: OLE_COLOR; RightBorderStyle: XlLineStyle; 18 RightBorderWidth: XlBorderWeight; RightBorderColor: OLE_COLOR; 19 BottomBorderStyle: XlLineStyle; BottomBorderWidth: XlBorderWeight; 20 BottomBorderColor: OLE_COLOR; DiagonalBorderStyle: XlLineStyle; 21 DiagonalBorderWidth: XlBorderWeight; DiagonalBorderColor: OLE_COLOR; 22 DiagonalBorderUp: WordBool; DiagonalBorderDown: WordBool); safecall; 23 property WorkBookCount: Integer read Get_WorkBookCount; 24 property WorkBooks[Index: Integer]: IWorkBook read Get_WorkBooks; 25 property ActiveBook: IWorkBook read Get_ActiveBook write Set_ActiveBook; 26 end; |
1.20.1. Свойства | ||||||||||||||||
Свойства интерфейса IWorkBooks:
|
1.20.2. Метод AddWorkBook | ||||||||
Метод интерфейса IWorkBooks. function IWorkBooks.AddWorkBook(WorkBook: IWorkBook): IWorkBook; Параметры:
Замечания: Возвращает значение типа IWorkBook. |
1.20.3. Метод CreateStyle | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Метод интерфейса IWorkBooks. 01procedure IWorkBooks.CreateStyle(ApplyNumberFormat: WordBool; 02 const NumberFormat: WideString; ApplyFont: WordBool; Bold: WordBool; 03 Italic: WordBool; Underline: WordBool; FontColor: OLE_COLOR; 04 ApplyFill: WordBool; BackgroundColor: OLE_COLOR; Pattern: XlPattern; 05 ApplyBorder: WordBool; LeftBorderStyle: XlLineStyle; 06 LeftBorderWidth: XlBorderWeight; LeftBorderColor: OLE_COLOR; 07 TopBorderStyle: XlLineStyle; TopBorderWidth: XlBorderWeight; 08 TopBorderColor: OLE_COLOR; RightBorderStyle: XlLineStyle; 09 RightBorderWidth: XlBorderWeight; RightBorderColor: OLE_COLOR; 10 BottomBorderStyle: XlLineStyle; BottomBorderWidth: XlBorderWeight; 11 BottomBorderColor: OLE_COLOR; DiagonalBorderStyle: XlLineStyle; 12 DiagonalBorderWidth: XlBorderWeight; DiagonalBorderColor: OLE_COLOR; 13 DiagonalBorderUp: WordBool; DiagonalBorderDown: WordBool); Параметры:
|
1.20.4. Метод RemoveWorkBook | ||||||||
Метод интерфейса IWorkBooks. procedure IWorkBooks.RemoveWorkBook(WorkBook: IWorkBook); Параметры:
|