Google Spreadsheet Reader Parameters

Enter a Google Docs username that has access to the spreadsheet to be read.

Enter a Google Docs password for the specified username.

Click the Browse button, and select the spreadsheet to be read.

Indicates whether the field names are specified in the spreadsheet file.

Indicates whether header lines appear before the field names in the spreadsheet file.

Enter the number of header rows in the spreadsheet.

Indicates whether the reader should read formulas from the spreadsheet or actual values.

Use this parameter to expose Format Attributes in Workbench when you create a workspace:

• In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
• In a non-dynamic scenario where you have multiple feature types, it is convenient to expose additional attributes from one parameter. For example, if you have ten feature types and want to expose the same attribute in each one, it is easier to define it once than it is to set each feature type individually in the workspace.