LAE

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

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

Originally posted by: dkhuon@gogoair.com
					

I have a node that produces an excel with 5 worksheets using 6 input pins (1 for each sheet + 1 for rundate).


I like to put the RunDate (pin 6) on the top of each of the 5 sheets.


I was able to do it, only for the 1st sheet.  The rest of the sheets do not have the date field, no matter which way I organize the output spec.  For example:


<workbook>
<sheet inputIndex="6" outputIndex="1" dataStartRow="2" dataStartColumn="1" headerRow="1"/>
<sheet inputIndex="1" outputIndex="1" dataStartRow="4" dataStartColumn="1" headerRow="3"/>

<sheet inputIndex="6" outputIndex="2" dataStartRow="2" dataStartColumn="1" headerRow="1"/>
<sheet inputIndex="2" outputIndex="2" dataStartRow="4" dataStartColumn="1" headerRow="3"/>

<sheet inputIndex="6" outputIndex="3" dataStartRow="2" dataStartColumn="1" headerRow="1"/>
<sheet inputIndex="3" outputIndex="3" dataStartRow="4" dataStartColumn="1" headerRow="3"/>

<sheet inputIndex="6" outputIndex="4" dataStartRow="2" dataStartColumn="1" headerRow="1"/>
<sheet inputIndex="4" outputIndex="4" dataStartRow="4" dataStartColumn="1" headerRow="3"/>

<sheet inputIndex="6" outputIndex="5" dataStartRow="2" dataStartColumn="1" headerRow="1"/>
<sheet inputIndex="5" outputIndex="5" dataStartRow="4" dataStartColumn="1" headerRow="3"/>

</workbook>


Output:


Output 1 looks good if I could to display the RunDate (pin 6) without header - see picture:
 


RunDate






2014-07-02






Level
Agreement_Number
Corporate_Code
Group_Code
Service


1
12345

abcd



1
12345

abcd





Output 2, 3, 4, 5 no RunDate from pin 6 row, see picture:

















Level
Agreement_Number
Group_Code
Group_Description
Corporate_Code


1
12345
abcd
xxxxxx



1
12345
abcd
xxxxxx




So 2 issues:

1. Remove Header for RunDate

2. Only 1st sheet shows RunDate


Thanks anyone for all the help I can get.

dave

			

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

<!-- 
 If you don't want to set the header, then set outputHeaderRow to false
 Then, delete the "headerRow" attribute, and remove 1 from the dataStartRow, since you won't have a headerRow and want your data to start at the top
-->
<sheet inputIndex="6" outputIndex="1" dataStartRow="1" dataStartColumn="1" outputHeaderRow="false"/>
<sheet inputIndex="1" outputIndex="1" dataStartRow="4" dataStartColumn="1" headerRow="3"/>

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