Please enable JavaScript to view this site.

Altova MapForce 2020 Enterprise Edition

After you add an "Excel 2007+" component to the mapping area, you can configure the settings applicable to it from the Component Settings dialog box. You can open the Component Settings dialog box in one of the following ways:

 

On the Component menu, click Properties (this menu item becomes enabled when you select a component).

Double-click the component header.

Right-click the component header, and then click Properties.

xlsx_component_settings

Component Settings dialog box

The available settings are as follows.

 

Component name

The component name is automatically generated when you create the component. However, you can change the name at any time.

 

The component name can contain spaces and full stop characters. It may not contain slashes, backslashes, colons, double quotes, leading or trailing spaces. If you want to change the name of the component, be aware of the following:

 

If you intend to deploy the mapping to FlowForce Server, the component name must be unique.

It is recommended to use only characters that can be entered at the command line. National characters may have a different encoding in Windows and at the command line.

Input Excel 2007+ file

Specifies the Microsoft Excel file from which MapForce will read data. This field is meaningful in a source component, when MapForce uses it to read the Excel worksheet names and columns.

 

To change the location of the file, click Browse and select the new file. To edit the file in Microsoft Excel, click Edit.

Output Excel 2007+ file

Specifies the name or path of the Microsoft Excel file to which MapForce will write data. This field is meaningful in a target component.

 

To change the location of the file, click Browse and select the new file. To edit the file in Microsoft Excel, click Edit.

 

If you do not specify an output file, MapForce generates the output to a file named xlsx-mapforce.xlsx. By default, this file is generated in the same folder as the .mfd file, unless you configured a different path.

 

Any existing data in the output Excel file will be overwritten when the mapping transformation runs.

Show error for type mismatch

Enables error messages in the Messages window, when mismatches occur between a data type declared in the component and data in the input .xlsx file.

 

For example, let's assume that this setting is enabled, and you declared a column as numeric in the Select range of cells dialog box. If the Excel file contains text data in this column, an error message is shown in the Messages window after you connect this column to some output and preview the output.

Save all file paths relative to MFD file

When this option is enabled, MapForce saves the file paths displayed on the Component Settings dialog box relative to the location of the MapForce Design (.mfd) file. See also Using Relative Paths on a Component.

© 2019 Altova GmbH