ILanerTable.SeriesList

Fore Syntax

SeriesList: ILanerSerieList;

Fore.NET Syntax

SeriesList: Prognoz.Platform.Interop.Laner:ILanerSerieList;

Description

The SeriesList property returns collection of workbook series.

Comments

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

Fore 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.

Fore.NET Example

The requirements and result of the Fore.NET example execution match with those in the Fore example.

Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Laner;
…
Public Shared Sub Main(Params: StartParams);
Var
    mb: IMetabase;
    WbkObj: IMetabaseObject;
    EaxAn: IEaxAnalyzer;
    Laner: ILaner;
    Table: ILanerTable;
    SeriesList: ILanerSerieList;
Begin
    // Get workbook
    mb := Params.Metabase;
    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
    System.Diagnostics.Debug.WriteLine("Number of workbook series " +
        WbkObj.Name + "»: " + SeriesList.Count.ToString());
End Sub;