Class TOLEExcel (unit OLEExcel)
Inherits from
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;