I need to read an Excel spreadsheet. I use user defined parameters to set a filename and a sheet name.
This is a simplified workflow:
This is a parameter I use:
and this is schema settings for FeatureReader
It gives me the following error:
Here is my test example
Best answer by takashi
Hi @victorddt, it doesn't seem that the FeatureReader treats the feature type name "INPUT" well. I would recommend you to contact Safe support to clarify what happened FME internal.
Hi @victorddt, it doesn't seem that the FeatureReader treats the feature type name "INPUT" well. I would recommend you to contact Safe support to clarify what happened FME internal.
+19Hi @victorddt,
Strange just trying to read the xls with a reader results in an error, possibly there is something wrong with the file you have provided. (using FME 2019.1.0.0)
Hi @victorddt,
Strange just trying to read the xls with a reader results in an error, possibly there is something wrong with the file you have provided. (using FME 2019.1.0.0)
Hi @itay. I use the same FME version. Have you tried my test file? It's attached below.
+19Hi @itay. I use the same FME version. Have you tried my test file? It's attached below.
Hi @victorddt, Yes that's the one I have used to try the workspace and a completely new workspace just trying to read the xls file.
Saving the file with INPUT2 seems to solve the problem, So I guess @takashi had it right the all time :)
+22Hi @victorddt, it doesn't seem that the FeatureReader treats the feature type name "INPUT" well. I would recommend you to contact Safe support to clarify what happened FME internal.
Hi @victorddt Yes, INPUT isn't a valid sheet name. I've filed FMEENGINE-61539 about this.
Hi @victorddt, it doesn't seem that the FeatureReader treats the feature type name "INPUT" well. I would recommend you to contact Safe support to clarify what happened FME internal.
@danatsafe Thank you for registering the ticket. I have tried to change the sheet name from "INPUT" to "MYDATA" and update the parameter and Excel accordingly.
Same result - I can see only "no schema" list.
+22@danatsafe Thank you for registering the ticket. I have tried to change the sheet name from "INPUT" to "MYDATA" and update the parameter and Excel accordingly.
Same result - I can see only "no schema" list.
Hi @victorddt MYDATA works for me. I think you just need to set the Features To Read on the FeatureReader.
