Setting a regex in the merge filter properties of the reader is no problem. The problem is what to write in Feature Type Name? The Feature Type Name always semmes seems to works as a reducing filter. If set to "Table" I only get the sheets named "Table". I've tried to use some kind of wildcard (*, %) without any luck.
Regards,
Daniel
+17
I don't think there is a way to resolve that by the reader settings.
After reading, feature type name can be changed with the AttributeCreator (assign appropriate name to "fme_feature_type") or the SchemaMapper (Feature Type Mapping scenario).
Takashi
I thought there was nothing FME couldn't do! ;)
So, does this mean there's no way to read Excel files if the sheet names aren't known?
/Daniel
+17
Selectable feature type names (worksheet names in this case) for the parameter will be configured when you specified source Excel file(s).
+3
Did the where clause parameter dissapear in this XLSXR reader???
The now depricated XLS_ADO reader has it.
thats a shame, or is it stuffed somewher hidden and mysterious?
Gio
+17
I feel that the XLSXR is much more efficient than the XLS_ADO. Probably it's reading Excel files directly without using ADO (a middle ware for database accessing).
I guess this is the reason that the XLSXR cannot have "where clause" parameter.
FME 2014 doesn't have XLS_ADO no longer...
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
