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.  Import Excel file and output the different sheets to different Pins

    Employee
    Posted 02-04-2015 19:58

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

    Originally posted by: dglavastorm

    Hi, hopefully the title says it all.

    I have an Excel workbook to import with 6 different sheets/tabs. Obviously I can run 6 Import nodes individually pulling in each sheet, but wondering if there is a quicker way to just have one node with 6 outputs pins. All sheets contain different data, although some share identical columns (eg. Report Date).

    Thanks,

    Dave


  • 2.  RE: Import Excel file and output the different sheets to different Pins

    Employee
    Posted 02-04-2015 20:41

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

    Originally posted by: ryeh

    See attached example. You can add multiple output pins to the Excel node. You can specify the options within the WorkbookSpec.
    Attachments:
    multiExcelOut.zip


  • 3.  RE: Import Excel file and output the different sheets to different Pins

    Employee
    Posted 02-05-2015 17:46

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

    Originally posted by: dglavastorm

    Perfect, thanks again Ryeh - Suggestion is to add the "outputIndex="2" text to the WorkbookSpecExample as this is the part we couldn't work out.