I have a dynamic Excel reader with a large number of tabs. I want to set both the "Field Names Row" and "Cell Range" at once. Is there any way to do them all instead of one at time?
Question
Excel Reader - is there a way to set Field Name range for tabs in bulk ?
+23- Contributor
Use the FeatureReder set to Microsoft Excel and check the Parameter "Scan Schema in Dynamic Workflow" in the Advanced section.
You can not set Cell Range via an attribute or parameter, you can opt for reading only Named Ranges in the FeatureReader parameters.
+1- Participant
What i'm trying to do is change ALL the field names and Cell Ranges at once instead of tab by tab --- eg
