List of Supported Formats

Search the Online Transformer Gallery

• Microsoft Excel (XLSXR/XLSXW) Reader/Writer
  • Quick Facts
  • Reader Parameters
  • Writer Parameters
  • Writer Feature Type Properties
    • XLSXW Writer: User Attributes
    • XLSXW Writer: Format Parameters
  • Tips for Using the Excel Writer
  • Feature Representation
  • Troubleshooting

Tips for Using the Excel Writer

• When inserting a feature into Excel, missing and null attributes on the feature will be written out as blank cells. Empty string attributes on the feature will be written out as empty strings.
• When updating existing Excel columns, null attributes on the feature will be written out as blank cells. Missing attributes on the feature will cause the corresponding cells to remain unmodified. Empty string attributes on the feature will be written out as empty strings.
• When constructing formulas, row(), column(), address(), and indirect() can be useful if the absolute address being written to is unknown. For example,

=INDIRECT(ADDRESS(ROW(), COLUMN()-1) ) +1

The value of the cell is equal to the value of cell in the preceding column plus one.