I have used a Directory and File Pathnames reader to generate an attribute holding file paths for the .xlsx files that I need to read in to my workbench. My plan was to use a FeatureReader to subsequently read these files in but I am struggling to get this to work.
There are multiple worksheets in each .xlsx and I only need the contents of one - in all cases the applicable worksheet has the same name and an identical schema, the column headers are all on the same row as well.
I haven’t been able to work out how to configure the FeatureReader as when specifying the dataset from an attribute the parameters to specify ‘Sheets to Read’ and ‘Field Names Row’ are not available.
I would be very grateful for any advice - thanks in advance.
Solved
How to read multiple Excel files using FeatureReader (filepath held as an attribute)
+7- Contributor
Best answer by mattebridges
Have just been able to resolve this by using the fme_feature_type_name attribute from the Schema output port of the feature reader to define the feature types to read in a subsequent feature reader.
Attributes can then be named correctly in a subsequent AttributeManager.
+7- Contributor
- Best Answer
Have just been able to resolve this by using the fme_feature_type_name attribute from the Schema output port of the feature reader to define the feature types to read in a subsequent feature reader.
Attributes can then be named correctly in a subsequent AttributeManager.
+64
I can’t demonstrate this at the moment as I have no license (I should not promote the software in my company, kills my productivity) but what I generally do is configure the FeatureReader reading the XLSX with a file. When this works, I only change the datapath field to an attribute.