ILanerTable.SeriesList

Syntax

SeriesList: ILanerSerieList;

Description

The SeriesList property returns collection of workbook series.

Comments

The returned collection enables the user to add and remove elements.

Example

Executing the example requires a workbook with the WORKBOOK_SERIES identifier that contains several series.

Add links to the Express, Laner and Metabase system assemblies.

Sub UserProc;
Var
    mb: IMetabase;
    WbkObj: IMetabaseObject;
    EaxAn: IEaxAnalyzer;
    Laner: ILaner;
    Table: ILanerTable;
    SeriesList: ILanerSerieList;
Begin
    // Get workbook
    mb := MetabaseClass.Active;
    WbkObj := mb.ItemById("WORKBOOK_SERIES").Bind;
    EaxAn := WbkObj As IEaxAnalyzer;
    Laner := EaxAn.Laner;
    // Get data table
    Table := Laner.Execute;
    // Get series collection
    SeriesList := Table.SeriesList;
    // Output the number of columns in the collection
    Debug.WriteLine("Number of workbook series " +
        WbkObj.Name + "»: " + SeriesList.Count.ToString);
End Sub UserProc;

After executing the example the console window displays the number of series of the WORKBOOK_SERIES workbook.