Versions Compared

Old Version 13

changes.mady.by.user Chandna Mitra

Saved on

compared with

New Version 14

changes.mady.by.user Chandna Mitra

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

On this Page

Table of Contents
maxLevel2
excludeOlder Versions|Additional Resources|Related Links|Related Information

Snap type:

Format


Description:

This Snap reads the documents from multiple input views, formats the data to XLSX format and converts them into specified sheet for each input view and writes out binary data.

  • Expected upstream Snaps: Any Snap that provides a document output view, such as Mapper or Structure or a JSON Generator Snap. 
  • Expected downstream Snaps: [None] or any Snap that has a binary input view, such as File Writer or JSON Parser.
  • Expected input: Document data to be formatted in to excel format. 
  • Expected output: This Snap provides the result of the formatted excel content in the binary output view.
Prerequisites:

[None].


Support and limitations:
  • Ultra pipelines: Does not work in Ultra Pipelines. 
    • Spark mode: Not supported in /wiki/spaces/SD/pages/1437917 modeNone.
    Account: 

    Accounts are not used with this Snap.


    Views:


    InputThis Snap has exactly one document input view.
    OutputThis Snap has exactly one binary output view.
    ErrorThis Snap has at most one document error view and produces zero or more documents in the view.


    Settings

    Label


    		Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

    Sheet mapping


    Specifies the mapping of input view to excel sheet name.


    Input view name

    Select the name of the input view to use from the list of views added to the Snap.


    Sheet name

    Name of the Excel sheet to map the input view data.
    This property accepts expressions to allow pipeline parameters only.


    Write header

    Required. This option specifies whether or not the Snap should write the header to the output.

    Default value: Selected


    Ignore empty stream

    If the property is not selected, an empty array will be written to the output view in case no documents were received on the input view. If the property is selected, the the Snap will write nothing to the output view in case no documents were received on the input view.

    Default value: Not selected

    Multiexcerpt include macro
    nameSnap Execution
    pageAnaplan Read


    Multiexcerpt include macro
    nameSnap_Execution_Introduced
    pageAnaplan Read

    Example

    Reading csv Files and Providing Input Data to the Excel Multi Sheet Formatter Snap

    The following image shows a sample pipeline that reads two csv files and providing the document data as input to Excel Multi Sheet Formatter Snap. 

    The following image displays the Excel Multi Sheet Formatter Snap properties, where input0 maps to a sheet named by the pipeline parameter sheetname and input1 maps to sheet2. 

    Insert excerpt
    Transform Snap Pack
    Transform Snap Pack
    nopaneltrue