LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  New output excel option question

    Employee
    Posted 04-02-2013 07:46

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

    Originally posted by: ThomasT

    The new output excel option is just great.

    Is it possible to make an output where i dont display the header?

    <!-- Output the 3rd input pin to the 2nd worksheet, with the first column blank,
    and with the header starting at row 1, and the data starting at row 3 (leaving a gap between header and data) -->
    <sheet inputIndex="3" outputIndex="2" dataStartRow="3" dataStartColumn="2" headerRow="1"/>


  • 2.  RE: New output excel option question

    Employee
    Posted 04-02-2013 08:01

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

    Originally posted by: Tim Meagher

    Hi,

    If you are appending to an existing worksheet, and not overwriting the entire worksheet, then this is the default behavior.
    If, however, you are writing to a new worksheet and don't want to output the header, then this is also possible.
    For example, you could use the following:

    <!-- Output the 3rd input pin to the 2nd worksheet, with the first column blank,
and with no header row, and the data starting at row 3 -->
<sheet inputIndex="3" outputIndex="2" dataStartRow="3" dataStartColumn="2" outputHeaderRow="false"/>


    Unfortunately, it looks like this got overlooked in the documentation of the OutputSpec parameter.
    This issue has been raised in Issue # 4799 to make sure it is correctly documented in future releases.

    Regards,
    Tim.