Microsoft Excel reporting and data analyzing with practically no coding. .Net, ActiveX, and VCL versions. www.AfalinaSoft.com  

Home    Products    Downloads    Registered users    Support    Prices    Order    Primary Subscription

 
MS Office COM Add-ins. Microsoft Excel reporting and data analyzing


XL Report units - AfalinaSoft XL Report Programmer's Reference

<< Previous

Table of contents

Next >>

Programmer's Reference

XL Report source code consists of several units publishing several classes, procedures, and global variables. This reference describes only those classes and procedures that you will work with. The reference doesn't describe the contents of the protected section of classes. The classes and procedures used by XL Report inner mechanisms are also omitted.

XL Report 4 includes also XL Report G2 (the previous version) classes having ported into the XL Report 4 core for compatibility only. They are described in the "XL Report G2 Programmer's Reference".


XL Report units

XL Report includes the following units:

  • xlcUtils - service functions;
  • xlcOPack - XL Option Pack classes;
  • xlcClasses - XL Report base classes;
  • xlReport - XL Report classes;
  • xlReportG2 - TxlReportG2 ported under XL Report core;
  • xlAbout - the About dialog;
  • xlReportReg - component registering and property editors (required in design-time package creation);
  • xlStdOPack, xlPivotOPack - XL Report standard options.
  • Excel8G2, Office8G2 and VBIDE8G2 - Excel 97 type libraries (they are reworked, so be sure to use them and not any others).

Global constants and variables

xlrOS

Unit: xlcUtils

var xlrOS: TxlrOS;
type
TxlrOS = (xosUnknown, xosWin95, xosWin98, xosWin98SE,
xosWinNT, xosWinME, xosWin2000, xosWinXP);

Returns OS version. Is initialized in the unit's initialization section.

xlrExcelVer

Unit: xlReport

var
xlrExcelVer: integer = 0;

Returns Excel version. Contains the correct value during report generation only. Contains 0 in all other cases.

xlrLCID

Unit: xlReport

var
xlrLCID: integer = LOCALE_USER_DEFAULT;

Returns locale identifier. Used as an lcid parameter in many methods of Excel interfaces. Become initialized during first report generation.

xlrDebug

Unit: xlReport

var
{$IFDEF XLR_DEBUG}
xlrDebug: boolean = true;
{$ELSE}
xlrDebug: boolean = false;
{$ENDIF XLR_DEBUG}

Returns true if the application is compiled with {$DEFINE XLR_DEBUG} this way turning on the "visualization" mode of report generation.


Functions and procedures

A1

Unit: xlReport

function A1(const Row, Column: integer): string;

Returns a relative cell reference in the A1 reference style, given specified row and column numbers.

A1Abs

Unit: xlReport

function A1Abs(const Row, Column: integer): string;

Returns an absolute cell reference in the A1 reference style, given specified row and column numbers.

R1C1

Unit: xlReport

function R1C1(const Row, Column: integer): string;

Returns an absolute cell reference in the R1C1 reference style, given specified row and column numbers.

R1C1OfRange

Unit: xlReport

function R1C1OfRange(IRange: IxlRange): string;

Returns an absolute range reference in the R1C1 reference style. Uses IRange.AddressLocale.

<< Previous

Table of contents

Next >>


Components

xlReport xlReport

Developed for

Delphi 4, 5, 6, 7
C++Builder 4, 5, 6

Excel version supported

MS Excel 97 (SR2)
MS Excel 2000
MS Excel 2002 (XP)
MS Excel 2003



[ Download it ]
[ Order now ]



We are Borland technology partner

Copyright © 1999-2006
All right reserved.
Privacy Policy

Write to WebMaster

Page Top
Add-in Express - COM Add-ins, Smart Tags and RTDS in C#, VB, C++, J#, and Delphi