Microsoft Excel (XLSXR)读者参数
Different feature types are read by default, depending on whether you make changes to the Reader Parameters (accessible from the Add Reader > Parameters button):
By default, all worksheets and named ranges are selected.You can use the Select button to filter the display.
- When you open the Reader Parameters, by default, all of the worksheets in the spreadsheet will be selected, and all named ranges will be deselected.This is so that all cell data is read into FME only once.
- If you add a reader without opening the Reader Parameters dialog, and there is more than one feature type, you will have to select the feature types to add.
Dynamic Schema
If you set Workflow Options toDynamic Schema, then all worksheets and all named ranges will be read into FME.
This option breaks the dependence on the source and destination schema.One merged feature type will be connected to one writer feature type that is configured for dynamic operation.The schema is not replicated on the workspace;therefore, if the source data changes, you will not have to update the workspace – FME will do this automatically.
This will result in duplicated data (since any information in a named range is also on the sheet that contains it), but it means that no feature types will be hidden by default.
Sheets to Read
This area shows all of the worksheets and named ranges in the Excel file.A named range is of the formsheetName/NamedRangeName。
注意:" data-mc-conditions="">注意:Tables are treated the same as named ranges, and will appear with the same form.
Example
In this example, the selected area is a named range: the name of the named range is日期_hatched, and it is on the sheeteggs。
The columnField Names Rowallows you to select which row contains the header names, and the columnCell Rangeallows you to restrict the information to read.If a cell in theField Names Rowis blank (if, for example, it is a merged cell), it will automatically be given the merged cell value.
The Select menu allows you to choose which worksheets/named ranges to read.By default, FME will selectAll。
If the columnField Names Rowvalue is set to zero (0), then the column names will be set to the Excel column lettersA, B, C,etc.This can be useful if there are no field names, or if they are not consistent.
Preview
This area shows a preview of the data (up to 100 rows) of the selected feature type (either feature or named range).As shown in the example here, if you select a header row from the Sheets to Read area, that row will be shown in boldface text.
Attributes
This area displays the attributes that were created for the feature type (schema scanned).
- Name:The attribute name that will be placed on resulting features.
- Type:The attribute type is listed in this column.You can change the attribute type by clicking on the field and selecting from the drop-down list.This only affects the resulting features if the selected attribute type is a coordinate type or a date type.
- Width:This value is ignored for attributes produced from this reader.
- Precision:This value is ignored for attributes produced from this reader.
字段类型 |
描述 |
布尔 |
布尔类型存储真/假数据。数据读取或和这样的字段写入必须始终有真或假的值。 FME表示作为布尔是和没有真假,分别为左右的时间内FME任何记录将反映这一点。圆跳闸值将被写为真/假预期。 |
CHAR(
|
字符字段存储固定长度字符串。宽度参数控制可以由字段被存储的字符的最大数目。没有填充所需的字符串长度超过这个宽度。 笔记: 遇到字符串有长度大于宽度仍然会返回;他们不会被截断。 宽度参数是唯一有价值的,如果功能将被传递给需要此信息的另一种格式。 |
约会时间 |
日期时间字段转换双打或字符串在Excel中FME的时间字符串格式,并使用从源文件中的格式和值单元格的值进行检测。请注意,无格式从Excel中的原始值保留。 YYYYMMDDHHmmSS.mmm (年,月,日,时,分,秒,毫秒) |
日期 | 日期字段转换双打或字符串在Excel中FME日期字符串格式,并使用从源文件的格式和值单元格的值进行检测。请注意,无格式从Excel中的原始值保留。 YYYYMMD (年月日) |
时间 | 时间字段转换双打或字符串在Excel中FME时间字符串格式,并使用从源文件的格式和值单元格的值进行检测。请注意,无格式从Excel中的原始值保留。 HHmmSS.mmm (小时,分,秒,毫秒) |
串 |
字符串字段存储可变长度的字符数据最多的32767个字符的长度。值大于32767被截断。 |
数 |
数字字段存储单,双精度浮点值。 |
y_coordinate z_coordinate |
坐标字段存储双精度浮点值。没有指定字段的精度和宽度的能力。如果X和Y坐标上读取要素类型指定,功能也将使用他们试图创建点几何。属性不被消耗的几何形状,因此它们仍然会出现在生产的特点。 如果您的电子表格数据中包含X / Y值或纬度/经度,FME自动行转换为几何。它承认了几何列的通用名称,如“纬度”和“经度”,让你瞬间可视化电子表格。 |
Filter
Filter a list of attributes by typing a key sequence into this field.For more information, seeUsage Notes。
Read Formulas (.formula)
If this parameter is selected, an attribute will be added to the workspace for columns that contain a formula.The reader reads formulas used to calculate the values of a cell and stores the formula in the attribute
Read Hyperlinks (.hyperlink)
If this parameter is selected, an
Read Formatting (.formatting)
If this parameter is selected, an
Multiple File Parameters
When you select multiple datasets to read, the reader parameters dialog shows the Excel data (for example, sheets to read, field start row, cell range) for only one file – usually the first file selected.Any changed parameters will apply only to the displayed file.
如果您选择 multiple reader datasets, any parameters you change for the displayed file may not be ideal for all files.附加文件设置lets you choose whether to apply the options from the first dataset to the other datasets (if the same sheet names occur), or otherwise use default reader settings.
使用FME默认设置:The parameters set in this dialog will apply only to the current file.Any additional files will use the reader’s default settings.
使用当前设置:The parameters in this dialog will apply to all additional files.没有te that any additional feature types in those files will not be picked up.
Advanced
默认情况下,Excel的阅读模式是固定的,基于阅读器的功能类型定义的架构。选择这个参数,如果运行的工作空间,当你需要FME确定从当前Excel文件的架构。
这允许您设置一个工作流程,其中例如,您可以编辑源Exce亚搏在线l文件,而无需编辑的工作空间。此参数通常会在配合使用添加读写器选项一个合并的功能类型。
此参数定义FME将如何读回空白单元格。
- 空值:空白单元格将被读回为空的输出功能属性。
- 失踪:空白单元格将被读回作为输出要素缺少的属性。
这个参数告诉读者,当它遇到合并单元格范围内的事。
- 如果选择(这是默认值),该值将被放置到包含在所述合并后的小区内的每个属性。
- 如果未选择,该范围的值仅被放置在含有它的第一属性的第一属性。
例如,如果存在的合并单元格范围A1:B2(它包含4个细胞),并且它的值是的TestString:
- 如果您选择展开合并单元格,您会收到两个特点与属性A =”的TestString”和B =”的TestString”。
- 如果你不选择展开合并单元格,您会收到带有属性的一个特征A =”的TestString”和B =
和一个功能,以A = 和B = 。