IEaxAnalyzeCore.LanerTable

Syntax

LanerTable: ILanerTable;

Description

The LanerTable property returns the data table from the time series database workbook.

Comments

To get workbook, use the IEaxAnalyzeCore.Laner property.

Example

Executing the example requires that the repository contains a workbook with the WORKBOOK identifier containing data series.

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

Sub UserProc;
Var
    mb: IMetabase;
    WbkObj: IMetabaseObject;
    EaxAn: IEaxAnalyzer;
    LanerTbl: ILanerTable;
    i, j: Integer;
Begin
    // Get workbook
    mb := MetabaseClass.Active;
    WbkObj := mb.ItemById("WORKBOOK").Edit;
    EaxAn := WbkObj As IEaxAnalyzer;
    // Get workbook table
    LanerTbl := EaxAn.LanerTable;
    // Switch the table to edit mode
    If Not LanerTbl.IsEditing Then
        LanerTbl.Edit;
    End If;
    // Fill the table with arbitrary numbers
    For i := 0 To LanerTbl.RowCount - 1 Do
        For j := 0 To LanerTbl.ColumnCount - 1 Do
            If LanerTbl.IsEditableCell(i, j) Then
                LanerTbl.Cell(i, j) := Math.RandBetween(0, 100);
            End If;
        End For;
    End For;
    // Exit the edit mode with saving the data
    LanerTbl.Post;
    WbkObj.Save;
End Sub UserProc;

After executing the example the data in the workbook will be replaced with arbitrary numbers.

See also:

IEaxAnalyzeCore