TXLReport Excel Type Library interfaces

Home Products Downloads Registered users Support Prices Order Primary Subscription

<< Previous

Table of contents

Next >>

The following is a list of Excel Type Library interfaces that you can use with TxlReport instance. The interfaces are available in event handlers of TxlReport only. You can use these interfaces to carry out some additional actions during report generation.

INames public read only

Points to the Workbook.Names interface.

property INames: IxlNames;
type

IxlNames = Excel8G2.Names;

This interface lets you access Names collection of a report workbook. Example:

var IName: IxlName;
begin
...

IName:=Report.INames.Item('Range01', EmptyParam, EmptyParam, xlrLCID);

...
end;

ITempSheet public read only

Points to the hidden worksheet (XLRPT_Tempsheet) in the report.

property ITempSheet: IxlWorksheet;
type

IxlWorksheet = Excel8G2._Worksheet;

This interface lets you access the hidden worksheet inserted by XL Report during report generation. Example:

Report.ITmpSheet.Range('qryMaster_Date').Value := StartDate;

IWorkbook public read only

Points to the Workbook interface.

property IWorkbook: IxlWorkbook;
type

IxlWorkbook = Excel8G2._Workbook;

This property lets you access the report workbook. Example:

Report.IWorkbook.Worksheets.Add(EmptyParam, EmptyParam, 1,EmptyParam, xlrLCID);

IWorkbooks public read only

Points to the Application.Workbooks collection interface.

property IWorkbooks: IxlWorkbooks;
type

IxlWorkbooks = Excel8G2.Workbooks;

This property lets you access the collection of all open workbooks in Excel. Example:

NewWorkbook := Report.IWorkbooks.Add(EmptyParam, xlrLCID);

IWorksheets public read only

Points to the Application.Worksheets collection interface.

property IWorksheets: IxlWorksheets
type

IxlWorkbooks = Excel8G2.Workbooks;

This property lets you access the collection of all worksheets of the report workbook. Example:

INewSheet := Report.IWorksheets.Add(EmptyParam, Report.ITempSheet,

EmptyParam, EmptyParam, xlrLCID);

IModule public read only

Points to the service module interface.

property IModule: IxlVBComponent;
type

IxlVBComponent = OLEVariant;

This property lets you access the service VBA module of the report workbook. You can use it in order to place some VBA code into the module.

IWorksheetFunction public read only

Points to Application.WorksheetFunction interface.

property IWorksheetFunction: IxlWorksheetFunction;
type

IxlWorksheetFunction = Excel8G2.WorksheetFunction;

This property lets you access an interface of Excel worksheet functions. You can use this property in order to fulfill some additional calculations by using Excel tools.