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


XLRDatasources class - AfalinaSoft Active XL Report Programmer's Reference

<< Previous

Table of contents

Next >>


XLRDatasources class

Zero-based collection of datasources (of XLRDatasource type) for the current report.


XLRDatasources Properties


Count (read only)

Returns the number of datasources in the collection.

Property Count As Long

Item (read only)

Returns a single XLRDatasource object from the collection of datasources, either by position or by name.

Property Item(Index As XLRDatasource

Because the Item property is the default property of XLRDatasources, the following two statements are equivalent:

Set dsrCustomers = ocxXLReport.Datasources.Item(0)
Set dsrCustomers = ocxXLReport.Datasources(0)

See also: XLRDatasource class, XLRDatasource.Dataset property, XLRDatasource.DatasetType property.



XLRDatasources Methods


Add

Adds a new XLRDatasource object to the XLRDatasources collection and returns it.

Function Add() As XLRDatasource

See also: XLRDatasources.Delete method, XLRDatasource class, XLRDatasource.Dataset property, XLRDatasource.DatasetType property.

Delete

Deletes a specified item from the XLRDatasources collection.

Sub Delete(Index)

See also: XLRDatasources.Add method, XLRDatasource class, XLRDatasource.Dataset property, XLRDatasource.DatasetType property.


<< Previous

Table of contents

Next >>



Components

axlr axlr.ocx

Data Access methods

  • ADO
  • DAO
  • RDO
  • custom data

Excel version supported

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



[ Download it ]
[ Order now ]

Copyright © 1999-2006
All right reserved.
Privacy Policy

Write to WebMaster

Page Top
Add-in Express - Visual tool for Office customization