Syntax

   FACTORY_DEF <ReaderKeyword> ExcelStyleFactory
   [FACTORY_NAME <factory name>]
   [INPUT FEATURE_TYPE <factory type>
      [<attribute name> <attribute value>]*
      [<feature function>]*]
   [ROW_OR_CELL (row|cell)]
   [NUMBER_FORMAT_STRING <FMEParsableText encoded string>]
   [FONT <FMEParsableText encoded string>]
   [FONT_COLOR <fme color triplet>]
   [PATTERN_COLOR <fme color triplet]
   [BACKGROUND_COLOR <fme color triplet>]
   [PATTERN_STYLE (FILLPATTERN_NONE|FILLPATTERN_SOLID|FILLPATTERN_GRAY50|FILLPATTERN_GRAY75|FILLPATTERN_GRAY25|FILLPATTERN_HORSTRIPE|FILLPATTERN_VERSTRIPE|FILLPATTERN_REVDIAGSTRIPE|FILLPATTERN_DIAGSTRIPE|FILLPATTERN_DIAGCROSSHATCH|FILLPATTERN_THICKDIAGCROSSHATCH|FILLPATTERN_THINHORSTRIPE|FILLPATTERN_THINVERSTRIPE|FILLPATTERN_THINREVDIAGSTRIPE|FILLPATTERN_THINDIAGSTRIPE|FILLPATTERN_THINHORCROSSHATCH|FILLPATTERN_THINDIAGCROSSHATCH|FILLPATTERN_GRAY12P5|FILLPATTERN_GRAY6P25)]
   [HORIZONTAL_ALIGNMENT (left|center|right)]
   [VERTICAL_ALIGNMENT (top|center|bottom)]
   [INDENT <integer>]
   [TEXT_ORIENTATION <integer>]
   [TEXT_CONTROL (wrap_text|shrink_cells|none)]
   [CELL_BORDER_COLOR <fme color triplet>]
   [CELL_BORDER_STYLE (BORDERSTYLE_NONE|BORDERSTYLE_THIN|BORDERSTYLE_MEDIUM|BORDERSTYLE_DASHED|BORDERSTYLE_DOTTED|BORDERSTYLE_THICK|BORDERSTYLE_DOUBLE|BORDERSTYLE_HAIR|BORDERSTYLE_MEDIUMDASHED|BORDERSTYLE_DASHDOT|BORDERSTYLE_MEDIUMDASHDOT|BORDERSTYLE_DASHDOTDOT|BORDERSTYLE_MEDIUMDASHDOTDOT|BORDERSTYLE_SLANTDASHDOT)]
   [ROW_HEIGHT <float>]
   [ATTRS_TO_STYLE <attr name>[ <attr name>]*]
   [HIDE_CELLS (true|false)]
   [LOCKED_CELLS (true|false)]
   [OUTPUT <output port> FEATURE_TYPE <feature type>
      [<attribute name> <attribute value>]*
      [<feature function>]*]*

Overview

   Creates a style string based off of the provided parameters and creates attributes containing it
   in different cases (case specified by ROW_OR_CELL). In the row styling case, it sets the
   attribute "xlsx_row_formatting" to the style string and in the cell case for every attribute
   "attrName" that is selected in ATTRS_TO_STYLE we set the attribute "attrName.formatting" to the
   style string

Parameters

   ROW_OR_CELL

      In Row mode we add an "xlsx_row_formatting" attribute to format the entire feature.
      In cell mode for every selected attribute, <attrName>, we add an attribute "<attrName>.formatting"
      in order to format that attribute on the feature, corresponding to a specific cell in a sheet.

   NUMBER_FORMAT_STRING

      A FMEParsableText encoded string that abides by Excel's format string rules

   FONT

      A FMEParsableText encoded string that follows FME's format for fonts:
         <fontname>,<size>[,<style>*,<effects>*]
         <style> is be one of {BOLD, ITALIC}
         <effects> is one of {STRIKEOUT, UNDERLINE}
         eg. Arial,12,BOLD,ITALIC,STRIKEOUT,UNDERLINE

   FONT_COLOR

      A comma separated FME RGB colour triplet string of the form <float>,<float>,<float>
      where each <float> is a normalized color between 0.0 and 1.0
      For example, 0,0,0 is black, 1,1,1 is white, 1,0,0 is red, and 0.5,0.5,0.5 is grey
      This sets the foreground color of the text.

   PATTERN_COLOR

      A comma separated FME RGB colour triplet string of the form <float>,<float>,<float>
      where each <float> is a normalized color between 0.0 and 1.0
      For example, 0,0,0 is black, 1,1,1 is white, 1,0,0 is red, and 0.5,0.5,0.5 is grey
      This sets the color of the background pattern of the cell(s).

   BACKGROUND_COLOR

      A comma separated FME RGB colour triplet string of the form <float>,<float>,<float>
      where each <float> is a normalized color between 0.0 and 1.0
      For example, 0,0,0 is black, 1,1,1 is white, 1,0,0 is red, and 0.5,0.5,0.5 is grey
      This sets the background color of the cell(s).

   PATTERN_STYLE

      Each of the listed choices correspond to a pattern style in Excel

   HORIZONTAL_ALIGNMENT

      Each of the listed choices correspond to a horizontal alignment in Excel

   VERTICAL_ALIGNMENT

      Each of the listed choices correspond to a vertical alignment in Excel

   INDENT

      An integer between 0 and 15 specifying how far from the left border of a cell contents should appear

   TEXT_ORIENTATION

      An integer between -90 and 90 specifying at which angle the contents of a cell should be rotated
      The default of 0 provided by excel represents standard unrotated values.
      Positive values represent counterclockwise rotated values.
      Negative values represent clockwise rotated values.

   TEXT_CONTROL

      Each of the listed choices correspond to a type of text control in Excel

   CELL_BORDER_COLOR

      A comma separated FME RGB colour triplet string of the form <float>,<float>,<float>
      where each <float> is a normalized color between 0.0 and 1.0
      For example, 0,0,0 is black, 1,1,1 is white, 1,0,0 is read, and 0.5,0.5,0.5 is grey

   CELL_BORDER_STYLE

      Each of the listed choices correspond to a cell border style in Excel

   ROW_HEIGHT

      A two digit precision float between 0 and 409.50 specifying the row height of a row.
      This parameter is only applied when ROW_OR_CELL is set to "row" otherwise it is ignored

   ATTRS_TO_STYLE

      A space-delimited list of attribute names that specify which attributes to style.
      This parameter is only applied when ROW_OR_CELL is set to "cell" otherwise it is ignored.

   HIDE_CELLS

      Either "true" or "false" to specify whether that cell should be hidden or not

   LOCKED_CELLS

      Either "true" or "false" to specify whether that cell should be locked or not