Addix.Selector












Products



Addix.Spline
Addix.Selector
Addix.Analysis
Addix.Finance

Selector



Overview
Functionality
Download
Documentation
References
Registration
News & Views
FUNCTIONALITY

The current release of the product implements the following object properties and methods:
Selector
Properties
Files - Collection of File objects.
Executing - Asynchronous execution flag.
Mode - Asynchronous/synchronous operation selection.
LogFile - Path and filename of activity log file.
Methods
Update() - Initiate extraction operation.
LogFile - Halt synchronous extraction operation.
Read(CriteriaFile) - Read external data selection definition file for Selector object.
Write(CriteriaFile) - Write external data selection definition file for Selector object.
File
Properties
Filename - Path and filename of target spreadsheet file.
References - Collection of Reference objects.
ErrorLog - Collection of errors encountered during data extraction.
Methods
Write(CriteriaFile) - Write external data selection definition file for File object.
Reference
Properties
Reference - Worksheet name, range or cell reference to extract data from.
Rows - Row range/indices of data to extract within reference.
Columns - Column range/indices of data to extract within reference.
Methods
Value(Headings) - Returns VARIANT array of extracted cell values.
ValueRS() - Returns ADO recordset of extracted cell values.
Formula(Headings) - Returns VARIANT array of extracted cell formulae.
FormulaRS() - Returns ADO recordset of extracted cell formulae.


For further detail on the properties and methods of the individual objects and collections, please refer to the User Guide which can be found on the documentation page.