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.  Add File to an existing Excel file as a new worksheet

    Employee
    Posted 05-09-2011 21:38

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

    Originally posted by: TheBishop

    Hi,

    Is there a way to add the output of a graph to an existing excel file as a new worksheet?

    My reasoning for this is that there is historical analysis of a particular month's data and I want to append my analysis of the latest revision. I can't bring in the previous analysis to lavastorm as it has been done in excel with graphs, formulas, pivot tables etc.

    My next best option is to output it and have the user manually move the sheet into the previous analysis' excel file.

    Cheers,

    Ben


  • 2.  RE: Add File to an existing Excel file as a new worksheet

    Employee
    Posted 05-10-2011 11:55

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

    Originally posted by: rboccuzzi

    Unfortunately, not at this time. The Output Excel node always takes all the data into it and writes the entire file. If you could get all the data into the LAE from the previous tabs, you could re-create the entire Excel file, just adding the last tab to it.

    I have filed enhancement PR3296 for this feature, but can't comment as to when it would be implemented at this time.

    Cheers
    Rich


  • 3.  RE: Add File to an existing Excel file as a new worksheet

    Employee
    Posted 05-15-2011 21:12

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

    Originally posted by: TheBishop

    Thanks for the info Rich, I'll go for the next best option.

    Cheers,

    Ben


  • 4.  RE: Add File to an existing Excel file as a new worksheet

    Employee
    Posted 11-14-2013 09:43

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

    Originally posted by: dwong80

    Following with this topic, are we able to add tabs to Excel in BRE 4.5.4 yet? If not, which version is able to support this?


  • 5.  RE: Add File to an existing Excel file as a new worksheet

    Employee
    Posted 11-14-2013 09:51

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

    Originally posted by: Tim Meagher

    Hi,

    The ability to add tabs to an existing workbook and append rows to an existing worksheet was added in LAE 4.6.0 (and enhanced a little in LAE 4.6.1) via the Append Excel node, and full support of the Output Excel node which was previously an experimental node.

    Regards,
    Tim.