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?
Page 1 / 1
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.
What i'm trying to do is change ALL the field names and Cell Ranges at once instead of tab by tab --- eg