Kitto.FlexCel

Flexcel support engine

TKFlexCelExportEngine class

Exports a KittoX view-table store (or a plain dataset) to an Excel file using FlexCel, optionally driven by an .xlsx/.xltx template.

procedure CreateFileByTable(const AFileName: string;

Creates a new Excel file from a view-table store, generating the sheet from its fields.

procedure CreateFileByDataSet(const AFileName: string;

Creates a new Excel file from a plain dataset, generating the sheet from its fields.

procedure CreateFileByTableWithTemplate(const AExcelFileName, ATemlateName, AExcelRangeName: string;

Creates an Excel file from a view-table store using an existing template workbook.

procedure CreateFileByDataSetWithTemplate(const AExcelFileName, ATemlateName, AExcelRangeName: string;

Creates an Excel file from a dataset using an existing template workbook.

TKFlexCelVirtualTable class

FlexCel virtual data table that exposes a KittoX view-table store as a data source for FlexCel report templates, without materializing a dataset.

constructor Create(const aTableName: UTF16String;

Creates the virtual table bound to the given view-table store.

function CreateState(const sort: UTF16String;

Creates the iteration state FlexCel uses to walk this table's rows.

function GetColumn(const columnName: UTF16String): Int32;

Returns the column index for the given column name.

function GetColumnName(const columnIndex: Int32): UTF16String;

Returns the (internal) name of the column at the given index.

function GetColumnCaption(const columnIndex: Int32): UTF16String;

Returns the display caption of the column at the given index.

TKFlexCelVirtualTableState class

Iteration state for TKFlexCelVirtualTable: tracks the current record position while FlexCel walks the store during report rendering.

constructor Create(const aTableData: TVirtualDataTable;

Creates the iteration state bound to the given virtual table and store.

function Eof: Boolean;

Returns True when the iteration has passed the last record.

procedure MoveFirst;

Positions on the first record of the store.

procedure MoveNext;

Advances to the next record of the store.

function GetValue(const column: Int32): TReportValue;

Returns the value of the given column in the current record.

function GetValue(const row: Int32;

Returns the value of the given column in the specified row.