TOExportTemplateProcessRows

Description

TOExportTemplateProcessRows contains a row definition for a particular worksheet.
Use this object to process a row in a template (the status of the template must be etsProcessingRows.

Properties

NameTypeDescription
StatusTOExportTemplateStatus
  • etsLoading: Load the template into the Template property. Then call LoadTemplate.
  • etsProcessingDocument: Document-wide template tags are processed.
  • etsProcessingRows: Row template tags are processed.
  • etsSaving: Save the generated document. Use the Document property.
Items[Index: Integer]TOExportTemplateProcessRowsStores the items.
CountIntegerItem count.

Functions for processing row-wide tags

function ReplaceSqlValue(const aOldSqlValue, aNewSqlValue: OWideString; const aNewCellClass: TExportCellClass): Integer;
Replace an old cell tag (in SQL format) with a new value (also in SQL format) and transform the target cell into the aNewCellClass type. All cells within the current row (and with the aOldSqlValue tag) will be replaced!
Use the functions from the FormatSQL unit to convert numbers, dates etc. to SQL and vice versa!
function ReplaceFormula(const aOldSqlValue, aNewFormula: OWideString; const aNewCellClass: TExportCellClass): Integer;
Replace an old cell tag (in SQL format) with a new value (formula) and transform the target cell into the aNewCellClass type. All cells within the current row (and with the aOldSqlValue tag) will be replaced!
Use the functions from the FormatSQL unit to convert numbers, dates etc. to SQL and vice versa!
function FindCellsBySqlValue(const aOldSqlValue: OWideString; out aCells: TExportCellArray): Integer;
Find cells with the aOldSqlValue within the current row and return them in an array. The result value is the array length.
The aCells array is emptied before finding cells.
function FindCellsBySqlValueContinue(const aOldSqlValue: OWideString; var aCells: TExportCellArray): Integer;
Find cells with the aOldSqlValue within the current row and return them in an array. The result value is the array length.
The aCells array is not emptied before finding cells but the found cells are added to the aCells array.
function FindSingleCellBySqlValue(const aOldSqlValue: OWideString): TExportCell;
Find the first cell with the aOldSqlValue within the current row and return it.
Categories