Google Sheets v4 Reader Feature Type Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace. This opens the Feature Type Parameter Editor.

Tip  To always display the editor in FME Workbench, you can select View > Windows > Parameter Editor.

General

All feature types share similar General parameters, which may include Feature Type Name, Reader or Writer information, and Geometry.

In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept Table or Index Qualifier prefixes on the output table feature type.

These parameters apply only to a selected feature type, not to the entire reader.

Important  If a feature type parameter corresponds to a reader-level parameter, then the reader parameter will be ignored and the feature type parameter will be used.

Schema Generation

These parameters determine how user attributes are mapped to columns on the worksheet.

Field Names Row

This optional parameter indicates the row number that contains the field names.

If not provided, then field names are column letters from Start Column up to End Column.

Start Column

The column from which to start mapping field names to user attributes.

Value: Must be a value between A and ZZZ.

End Column

The column at which to stop mapping field names to user attributes. The writer will write up to and including this column.

Value: Must be a value between A and ZZZ.

Sheet Options

Start Row

The row number of the first feature. The value must be greater than Field Names Row.

Data End Row

The row at which to end reading. Cell values will be read up to and including this row. If this parameter is not specified, then all rows following Start Row are read. Empty rows are never read.

Read Blank Cells As

  • Missing: The attribute is not added to the feature if its value is blank.
  • Null: Blank values are set on the feature with a null value.
  • Empty String: Blank values are set on the feature as an empty string.

Render Values As

  • Formatted Value: Read calculated and formatted values. In this context, this excludes text formatting such as bold and italics.
  • Unformatted Value: Read calculated but unformatted values.
  • Formula: Read uncalculated and unformatted values.

Render Datetimes As

  • Serial Number: Read date, time, datetime, and duration values as a decimal, where the whole number portion represents days after 1899-12-30, and the fractional portion as a fraction of a day.
  • Formatted String: Read date, time, datetime, and duration values as they appear in the web interface.