Интерфейс 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 property Value[Row: Integer; Col: Integer]: OleVariant read Get_Value 239 write Set_Value; 240 property FormulasDocument: OleVariant read Get_FormulasDocument; 241 property DefaultColWidth: Single read Get_DefaultColWidth 242 write Set_DefaultColWidth; 243 property DefaultRowHeight: Single read Get_DefaultRowHeight 244 write Set_DefaultRowHeight; 245 property DefaultFontName: WideString read Get_DefaultFontName 246 write Set_DefaultFontName; 247 property DefaultFontSize: Single read Get_DefaultFontSize 248 write Set_DefaultFontSize; 249 property Accessible[Row: Integer; Col: Integer]: WordBool read Get_Accessible; 250 property Text[Row: Integer; Col: Integer]: WideString read Get_Text; 251 property FormulaText[Row: Integer; Col: Integer]: WideString 252 read Get_FormulaText write Set_FormulaText; 253 property FormulaNode[Row: Integer; Col: Integer]: OleVariant 254 read Get_FormulaNode write Set_FormulaNode; 255 property HasFormula[Row: Integer; Col: Integer]: WordBool read Get_HasFormula; 256 property Comment[Row: Integer; Col: Integer]: WideString read Get_Comment 257 write Set_Comment; 258 property NumberFormat[Row: Integer; Col: Integer]: WideString 259 read Get_NumberFormat write Set_NumberFormat; 260 property FontName[Row: Integer; Col: Integer]: WideString read Get_FontName 261 write Set_FontName; 262 property FontSize[Row: Integer; Col: Integer]: Single read Get_FontSize 263 write Set_FontSize; 264 property Bold[Row: Integer; Col: Integer]: WordBool read Get_Bold write Set_Bold; 265 property Italic[Row: Integer; Col: Integer]: WordBool read Get_Italic 266 write Set_Italic; 267 property Underline[Row: Integer; Col: Integer]: WordBool read Get_Underline 268 write Set_Underline; 269 property FontColor[Row: Integer; Col: Integer]: OLE_COLOR read Get_FontColor 270 write Set_FontColor; 271 property BackgroundColor[Row: Integer; Col: Integer]: OLE_COLOR 272 read Get_BackgroundColor write Set_BackgroundColor; 273 property WrapText[Row: Integer; Col: Integer]: WordBool read Get_WrapText 274 write Set_WrapText; 275 property HorizontalAlignment[Row: Integer; Col: Integer]: XlHAlign 276 read Get_HorizontalAlignment write Set_HorizontalAlignment; 277 property VerticalAlignment[Row: Integer; Col: Integer]: XlHAlign 278 read Get_VerticalAlignment write Set_VerticalAlignment; 279 property IndentLevel[Row: Integer; Col: Integer]: Integer read Get_IndentLevel 280 write Set_IndentLevel; 281 property Locked[Row: Integer; Col: Integer]: WordBool read Get_Locked 282 write Set_Locked; 283 property Pattern[Row: Integer; Col: Integer]: XlPattern read Get_Pattern 284 write Set_Pattern; 285 property Orientation[Row: Integer; Col: Integer]: XlOrientation 286 read Get_Orientation write Set_Orientation; 287 property RightBorderStyle[Row: Integer; Col: Integer]: XlLineStyle 288 read Get_RightBorderStyle write Set_RightBorderStyle; 289 property RightBorderWidth[Row: Integer; Col: Integer]: XlBorderWeight 290 read Get_RightBorderWidth write Set_RightBorderWidth; 291 property RightBorderColor[Row: Integer; Col: Integer]: OLE_COLOR 292 read Get_RightBorderColor write Set_RightBorderColor; 293 property BottomBorderStyle[Row: Integer; Col: Integer]: XlLineStyle 294 read Get_BottomBorderStyle write Set_BottomBorderStyle; 295 property BottomBorderWidth[Row: Integer; Col: Integer]: XlBorderWeight 296 read Get_BottomBorderWidth write Set_BottomBorderWidth; 297 property BottomBorderColor[Row: Integer; Col: Integer]: OLE_COLOR 298 read Get_BottomBorderColor write Set_BottomBorderColor; 299 property TopBorderStyle[Row: Integer; Col: Integer]: XlLineStyle 300 read Get_TopBorderStyle write Set_TopBorderStyle; 301 property TopBorderWidth[Row: Integer; Col: Integer]: XlBorderWeight 302 read Get_TopBorderWidth write Set_TopBorderWidth; 303 property TopBorderColor[Row: Integer; Col: Integer]: OLE_COLOR 304 read Get_TopBorderColor write Set_TopBorderColor; 305 property LeftBorderStyle[Row: Integer; Col: Integer]: XlLineStyle 306 read Get_LeftBorderStyle write Set_LeftBorderStyle; 307 property LeftBorderWidth[Row: Integer; Col: Integer]: XlBorderWeight 308 read Get_LeftBorderWidth write Set_LeftBorderWidth; 309 property LeftBorderColor[Row: Integer; Col: Integer]: OLE_COLOR 310 read Get_LeftBorderColor write Set_LeftBorderColor; 311 property DiagonalBorderStyle[Row: Integer; Col: Integer]: XlLineStyle 312 read Get_DiagonalBorderStyle write Set_DiagonalBorderStyle; 313 property DiagonalBorderWidth[Row: Integer; Col: Integer]: XlBorderWeight 314 read Get_DiagonalBorderWidth write Set_DiagonalBorderWidth; 315 property DiagonalBorderColor[Row: Integer; Col: Integer]: OLE_COLOR 316 read Get_DiagonalBorderColor write Set_DiagonalBorderColor; 317 property DiagonalBorderUp[Row: Integer; Col: Integer]: WordBool 318 read Get_DiagonalBorderUp write Set_DiagonalBorderUp; 319 property DiagonalBorderDown[Row: Integer; Col: Integer]: WordBool 320 read Get_DiagonalBorderDown write Set_DiagonalBorderDown; 321 property HyperLink[Row: Integer; Col: Integer]: WideString read Get_HyperLink 322 write Set_HyperLink; 323 property ColCount: Integer read Get_ColCount; 324 property RowCount: Integer read Get_RowCount; 325 property Width[Col: Integer]: Single read Get_Width write Set_Width; 326 property ColWidth[Col: Integer]: Single read Get_ColWidth write Set_ColWidth; 327 property ColHasPageBreak[Col: Integer]: WordBool read Get_ColHasPageBreak 328 write Set_ColHasPageBreak; 329 property Height[Row: Integer]: Single read Get_Height write Set_Height; 330 property RowHeight[Row: Integer]: Single read Get_RowHeight write Set_RowHeight; 331 property RowHasPageBreak[Row: Integer]: WordBool read Get_RowHasPageBreak 332 write Set_RowHasPageBreak; 333 property SheetName: WideString read Get_SheetName write Set_SheetName; 334 property SheetVisible: XlSheetVisibility read Get_SheetVisible 335 write Set_SheetVisible; 336 property SheetOrientation: XlPageOrientation read Get_SheetOrientation 337 write Set_SheetOrientation; 338 property SheetPaperSize: XlPaperSize read Get_SheetPaperSize 339 write Set_SheetPaperSize; 340 property SheetBlackAndWhite: WordBool read Get_SheetBlackAndWhite 341 write Set_SheetBlackAndWhite; 342 property SheetZoom: Integer read Get_SheetZoom write Set_SheetZoom; 343 property SheetFitPage: WordBool read Get_SheetFitPage write Set_SheetFitPage; 344 property SheetFitPageWidth: Integer read Get_SheetFitPageWidth 345 write Set_SheetFitPageWidth; 346 property SheetFitPageHeight: Integer read Get_SheetFitPageHeight 347 write Set_SheetFitPageHeight; 348 property SheetLeftMargin: Single read Get_SheetLeftMargin 349 write Set_SheetLeftMargin; 350 property SheetTopMargin: Single read Get_SheetTopMargin write Set_SheetTopMargin; 351 property SheetRightMargin: Single read Get_SheetRightMargin 352 write Set_SheetRightMargin; 353 property SheetBottomMargin: Single read Get_SheetBottomMargin 354 write Set_SheetBottomMargin; 355 property SheetHeaderMargin: Single read Get_SheetHeaderMargin 356 write Set_SheetHeaderMargin; 357 property SheetFooterMargin: Single read Get_SheetFooterMargin 358 write Set_SheetFooterMargin; 359 property SheetHorizontalCenter: WordBool read Get_SheetHorizontalCenter 360 write Set_SheetHorizontalCenter; 361 property SheetVerticalCenter: WordBool read Get_SheetVerticalCenter 362 write Set_SheetVerticalCenter; 363 property SheetHeaderFooterAlignWithMargins: WordBool 364 read Get_SheetHeaderFooterAlignWithMargins 365 write Set_SheetHeaderFooterAlignWithMargins; 366 property SheetHeaderFooterScaleWithDoc: WordBool 367 read Get_SheetHeaderFooterScaleWithDoc write Set_SheetHeaderFooterScaleWithDoc; 368 property SheetHeaderFooterHasFirst: WordBool read Get_SheetHeaderFooterHasFirst 369 write Set_SheetHeaderFooterHasFirst; 370 property SheetHeaderFooterHasEven: WordBool read Get_SheetHeaderFooterHasEven 371 write Set_SheetHeaderFooterHasEven; 372 property SheetHeaderFooter[Index: TSheetHeaderFooter]: WideString 373 read Get_SheetHeaderFooter write Set_SheetHeaderFooter; 374 property FixedCols: Integer read Get_FixedCols write Set_FixedCols; 375 property FixedRows: Integer read Get_FixedRows write Set_FixedRows; 376 property Zoom: Integer read Get_Zoom write Set_Zoom; 377 property TabColor: OLE_COLOR read Get_TabColor write Set_TabColor; 378 property BackgroundImage: OleVariant read Get_BackgroundImage 379 write Set_BackgroundImage; 380 property SummaryCol: XlSummaryColumn read Get_SummaryCol write Set_SummaryCol; 381 property SummaryRow: XlSummaryRow read Get_SummaryRow write Set_SummaryRow; 382 property ColOutline[Col: Integer]: Integer read Get_ColOutline 383 write Set_ColOutline; 384 property ColCollapsed[Col: Integer]: WordBool read Get_ColCollapsed 385 write Set_ColCollapsed; 386 property RowOutline[Row: Integer]: Integer read Get_RowOutline 387 write Set_RowOutline; 388 property RowCollapsed[Row: Integer]: WordBool read Get_RowCollapsed 389 write Set_RowCollapsed; 390 property ShrinkToFit[Row: Integer; Col: Integer]: WordBool read Get_ShrinkToFit 391 write Set_ShrinkToFit; 392 end;