The Excel expression is used to pass field values to Excel files. FDM uses the expression to automate Excel, to pass a field value into cell A1 and to return the value found in cell A2. This feature enables Excel worksheets to function as custom evaluation tools. The value in cell A2 can contain a standard Excel function or a custom VBA function.
To define Excel parsing expressions, follow this form: Excel=YourFileName.xls. Set the Excel file to append Excel to imported descriptions by using =A1&”Excel” for the value of cell A2.
The Excel file must be located in the <application name>\Data\Scripts\Import\ directory.
The Excel expression may consume a large amount of system resources, because Excel must run during the load process. In most cases, the Script expression, rather than the Excel expression, should be used.
Excel must be installed on the application server.