LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jchartrand

I have a directory with dozens of excel documents, each with a different number of worksheets. Any number, some 1,3,8,15 etc...

The metadata for these worksheets is the same on all worksheet except worksheet 1.

1. Is there a way that I can use the Excel File node to load ALL worksheets?
2. If one worksheet is consistently named "WORKSHEET" can I set the header row for that specific worksheet to be different then all others?

Thanks!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Since I can't see your sample files I can't be sure that this will work 100%

Try setting up the Excel node with at least 3 output pins
and set ConcatenationMode="Exact New Output"

and try this workbook spec:
<workbook>
<generatedFields>
<field type="filename" />
<field type="sheet" name="SheetInFile" />
</generatedFields>
</workbook>

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

To add a twist to Josh's problem, the header row is on row 5. What I was thinking was doing something like:

<workbook>
<sheet headerRow="5" />
<sheet headerRow="5" />
.
.
.
<generatedFields>
<field type="sheet" />
</generatedFields>
</workbook>

Basically repeating the '<sheet headerRow="5" />' line n times, where n is the maximum number of tabs he's expecting. Then setting the MetadataOutputPin parameter, which gives you the BRD files for each tab. Is there an easier way?