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;