| Class TOLEExcel (unit OLEExcel) |
TComponent
| Constructors |
constructor Create ( AOwner : TComponent );| Functions |
procedure CreateExcelInstance;
destructor Destroy;
function IsCreated: Boolean;
procedure QueryToExcel( const Query: TQuery );
procedure StringGridToExcel( const StringGrid: TStringGrid );
procedure TableToExcel( const Table: TTable );
function GetCell(ACol, ARow: Integer): string;
function GetDateCell(ACol, ARow: Integer): TDateTime;
procedure SetCell(ACol, ARow: Integer; const Value: string);
procedure SetCellFont( NewFont: TFont );
procedure SetDateCell(ACol, ARow: Integer; const Value: TDateTime);
procedure SetTitleFont( NewFont: TFont );
procedure SetVisible(DoShow: Boolean);
procedure GetFixedCols( const StringGrid: TStringGrid; var Cell: Variant );
procedure GetFixedRows( const StringGrid: TStringGrid; var Cell: Variant );
procedure GetQueryColumnName( const Query: TQuery; var Cell: Variant );
procedure GetStringGridBody( const StringGrid: TStringGrid; var Cell: Variant );
procedure GetTableColumnName( const Table: TTable; var Cell: Variant );
procedure SetExcelCellFont( var Cell: Variant );
procedure SetExcelTitleFont( var Cell: Variant );| Properties |
property CellFont : TFont
property IgnoreFont : Boolean
property TitleFont : TFont
property Visible : Boolean
property Cell : string
property DateCell : TDateTime| Events |
| Variables |
FCellFont : TFont;
FExcel : Variant;
FExcelCreated : Boolean;
FFontChanged : Boolean;
FIgnoreFont : Boolean;
FTitleFont : TFont;
FVisible : Boolean;
FWorkBook : Variant;
FWorkSheet : Variant;| Constructors |
constructor Create ( AOwner : TComponent );| Functions |
procedure CreateExcelInstance;
destructor Destroy;
function IsCreated: Boolean;
procedure QueryToExcel( const Query: TQuery );
procedure StringGridToExcel( const StringGrid: TStringGrid );
procedure TableToExcel( const Table: TTable );
function GetCell(ACol, ARow: Integer): string;
function GetDateCell(ACol, ARow: Integer): TDateTime;
procedure SetCell(ACol, ARow: Integer; const Value: string);
procedure SetCellFont( NewFont: TFont );
procedure SetDateCell(ACol, ARow: Integer; const Value: TDateTime);
procedure SetTitleFont( NewFont: TFont );
procedure SetVisible(DoShow: Boolean);
procedure GetFixedCols( const StringGrid: TStringGrid; var Cell: Variant );
procedure GetFixedRows( const StringGrid: TStringGrid; var Cell: Variant );
procedure GetQueryColumnName( const Query: TQuery; var Cell: Variant );
procedure GetStringGridBody( const StringGrid: TStringGrid; var Cell: Variant );
procedure GetTableColumnName( const Table: TTable; var Cell: Variant );
procedure SetExcelCellFont( var Cell: Variant );
procedure SetExcelTitleFont( var Cell: Variant );| Properties |
property CellFont : TFont
property IgnoreFont : Boolean
property TitleFont : TFont
property Visible : Boolean
property Cell : string
property DateCell : TDateTime| Events |
| Variables |
FCellFont : TFont;
FExcel : Variant;
FExcelCreated : Boolean;
FFontChanged : Boolean;
FIgnoreFont : Boolean;
FTitleFont : TFont;
FVisible : Boolean;
FWorkBook : Variant;
FWorkSheet : Variant;