One entry represents one mapping, i.e. mapping from fields of this application to Excel Page:cell
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
XLHINR | INR of Excel File | Text | 8 | 1 | Edit | Yes | Public | ||
SHEET | Name of the Excel sheet to work with | Text | 255 | 1 | Edit | Yes | Public | ||
VALUENAME | Name of the value | Text | 80 | 1 | Edit | Yes | Public | ||
CELL | Cell coordinates (e.g. A1, B2, etc) | Text | 40 | 1 | Edit | Yes | Public | ||
DSTGRP | Destination Group | Text | 9 | 1 | Edit | Yes | Public | ||
DST | Destination Field | Text | 60 | 1 | Edit | Yes | Public | ||
DIR | Direction | Text | 1 | 1 | Edit | Yes | Public | Embedded |
Name | Fields | Properties |
---|---|---|
XLM_DIR | DIR, XLHINR | |
XLM_DST | DSTGRP, DST, DIR | |
XLM_XLHINR | XLHINR |
/
CELL, XLHINR
Unique internal ID to link this table with table “Header for Excel Mapping” (XLH).
Sheet name (register tab) of the Excel.
Definition of cell coordinates, e.g. A1, B2 etc. for mapping.
Destination Group definition.
Defines the destination field of mapping.
Direction of mapping as per embedded codetable, which could be either from this application to Excel or from Excel to this application.
Code | Text |
---|---|
> | DOKA → EXCEL |
< | EXCEL → DOKA |