ExcelStyler

Sets Excel row and cell styling using attributes on output features destined for the Excel Writer. By default, all style values are empty and imply that no additional styling will be added. This allows any styling that may have existed from the Excel reader or user created attributes to persist. All style options on the ExcelStyler are optional.

Parameters

Apply Style To

Number Format

Font

Fill

Cell Border

Text Alignment

Cell Protection

Usage Notes

For more information regarding Excel styling, see the FME Readers and Writers help topic Microsoft Excel Writer Parameters. In particular, see the Formatting section under Usage Notes.

Editing Transformer Parameters

Using a set of menu options, transformer parameters can be assigned by referencing other elements in the workspace. More advanced functions, such as an advanced editor and an arithmetic editor, are also available in some transformers. To access a menu of these options, click beside the applicable parameter. For more information, see Transformer Parameter Menu Options.

Defining Values

There are several ways to define a value for use in a Transformer. The simplest is to simply type in a value or string, which can include functions of various types such as attribute references, math and string functions, and workspace parameters. There are a number of tools and shortcuts that can assist in constructing values, generally available from the drop-down context menu adjacent to the value field.

Dialog Options - Tables

Transformers with table-style parameters have additional tools for populating and manipulating values.

FME Community

The FME Community is the place for demos, how-tos, articles, FAQs, and more. Get answers to your questions, learn from other users, and suggest, vote, and comment on new features.

Search for samples and information about this transformer on the FME Community.