FME Transformers: 2025.1 BETA

Categories
Cartography and Reports
Database
Format Specific
Related Transformers
ExcelStyler

ExcelConditionalFormatter

Sets conditional rules and styles on features destined for Excel formats.

Jump to Configuration

Typical Uses

  • Preparing data for presentation in Excel.

How does it work?

The ExcelConditionalFormatter creates a Conditional Formatting rule that can be managed in Excel using the Conditional Formatting Rules Manager dialog.

Multiple rules can be added by chaining additional transformers together.

When adding multiple attributes to the rule, values such as average, rank, unique or duplicate values are evaluated across the entire combined range and not just the single attribute column.

Usage Notes

  • Excel formulas that return an error will not apply the style. Testing formulas in Excel is recommended.
  • 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.

Configuration

Parameters

Editing Transformer Parameters

Transformer parameters can be set by directly entering values, using expressions, or referencing other elements in the workspace such as attribute values or user parameters. Various editors and context menus are available to assist. To see what is available, click beside the applicable parameter.

For more information, see Transformer Parameter Menu Options.

Reference

Processing Behavior

Feature-Based

Feature Holding

No

Dependencies None
Aliases  
History  

FME Community

The FME Community has a wealth of FME knowledge with over 20,000 active members worldwide. Get help with FME, share knowledge, and connect with users globally.

Search for all results about the ExcelConditionalFormatter on the FME Community.

 

Examples may contain information licensed under the Open Government Licence – Vancouver, Open Government Licence - British Columbia, and/or Open Government Licence – Canada.