Google Sheets v4 Reader Feature Type Parameters
|
To access feature type parameters, click the gear icon 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.
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.
on a feature type in the