Kitto.Excel

TKExcelExportEngine class

Exports a KittoX view-table store (or a plain dataset) to an Excel file via ADOX/ADO, optionally filling a named range in a template workbook.

procedure CreateFileByTable(const AFileName: string;

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

procedure CreateFileByDataSet(const AFileName: string;

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

procedure FillAdoTable(const AExcelFileName, AExcelRangeName: string;

Fills the named range of an existing Excel file with the rows of a view-table store.

procedure FillAdoTableByDataSet(const AExcelFileName, AExcelRangeName: string;

Fills the named range of an existing Excel file with the rows of a dataset.

TKExcelImportEngine class

Imports rows from an Excel file into a KittoX view table, with optional field-name mapping and accept/set-value/before-post callbacks.

function GetFieldMappingName(const ASourceField: TField;

Resolves the destination field name for a source Excel field using the given mappings.

procedure ImportFileIntoViewTable( const AFileName: string;

Imports all accepted records from the Excel file into the given view table.

property OnDatabaseError : TImportDatabaseErrorEvent read FOnDatabaseError write FOnDatabaseError;

Fired when a database error occurs during import; the handler may choose to ignore it.