You are here: Popular FormatsMicrosoft Excel (XLSXR/XLSXW) Reader/WriterTips for Using the Excel Writer

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.