span8
span4
span8
span4
I would like to be able to choose the Worksheet to read from an XLS/XLSX file by the order it appears in the file, rather than have to specify the name.I have recently had to batch process a large number of Excel files where the Worksheet names were not known.There didn't seem to be a satisfactory way of dealing with this (I searched the Knowledge Center) so I end up creating 2 Workspaces and using the SchemaReader, WorkspaceRunner and FeatureReader to do what I needed.Even then, the process crashes randomly if I try to process more than 2 pairs of Excel files at a time (FME 2016.1, need to try in FME 2017).
It would have been a lot easier if I could have specified the Worksheet number in the Excel Reader, as I was always only reading the first Worksheet and the name wasn't important.OK, so I only had one Worksheet in each Excel file, but for multiple sheets you could specify which numbers you wanted e.g.read sheets 1,3,4,6 (or zero based if you prefer).Worksheet name could be exposed as a Format Attribute.
david_rcommented·
Great idea.It's also a hassle when you have to read several Excel files and the sheet names differ slightly between them, this could be very useful in those cases.
Maybe a format attribute like "xslx_sheet_id" could be implemented on the dynamic reader without too much trouble?It would be a nice complement to the existing "xlsx_row_id", I think.
The sheet name is actually already exposed in fme_feature_type.
Share your great idea, or help out by voting for other people's ideas.
Support multiple column / field constraints for Postgres Reader and Writer
Bug: Excel Writer Removes All Worksheet Protections From Existing Excel Template File
Add Schlumberger Petrel Reader and Writer
Ability to style column headers in Excel writer
Excel writer: push rows down when writing
Set Excel Template Sheet in Feature Type Properties
© 2020 Safe Software Inc |Legal