LAE

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

Originally posted by: mgp

I am trying to output three worksheets through the excel output node. I added three outputs on the IO tab and it works for sheet 2 and 3 however the first output should be from sheet 1 and it is outputting sheet 3.

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

Originally posted by: stonysmith

Slightly confused here.. do you mean the Excel INPUT node?
Or are you adding INPUT pins to the Excel Output node?


=======
To be able to read in multiple sheets into LAE, you need to configure the WorkbookSpec parameter with something like this:
<workbook>
<sheet index="1" outputIndex="1" />
<sheet index="2" outputIndex="2" />
<sheet index="3" outputIndex="3" />
</workbook>

=======
To be able to write out multiple sheets to a single Excel file, you just add input pins to the ExcelOut node, and make sure that they have unique names - the sheets will be named the same as the input pin names.