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?
+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.
What i'm trying to do is change ALL the field names and Cell Ranges at once instead of tab by tab --- eg
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.