Versions Compared

Old Version 15

changes.mady.by.user Kalpana Malladi

Saved on

compared with

New Version Current

changes.mady.by.user Cindy Hall

Saved on

Key

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

On In  this Pagearticle

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

Snap type:

Format

Description:

This Snap reads

Overview

Excel Multi Sheet Formatter is a Format-type Snap that 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:

    .

    Prerequisites

    None.

    Support for Ultra Pipelines

    Does not work in Ultra Pipelines.

    Limitations and Known Issues

    None.

    Snap Input and Output

    Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
    InputDocument
    Min: 1
    Max: ∞
    • Mapper
    • Structure
    • JSON Generator 
    		Document data to be formatted in to excel format. 
    Expected output:
    OutputBinary
    Min: 1
    Max: 1
    • File Writer
    • JSON Parser
    		This Snap provides the result of the formatted excel content in the binary output view
    .Prerequisites:None
    .
    Support and limitations:Does not work in Ultra Pipelines.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


    Snap Settings

    Specifies Required. This option specifies whether or not the Snap should If the property is not selectedname

    Field

    Field Type

    Description


    Label*


    		String

    Specify a unique 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.

    Pipeline.

    Default Value: Excel Multi Sheet Formatter
    Example: Excel Multi Sheet Formatter

    Sheet mapping


    Use this field set to define the mapping of input view to excel sheet name. This field set contains the following fields:

    • Input view name
    • Sheet name
    Input view nameString

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

    		Sheet name

    Name the sheet.

    Default Value: input0
    Example: input1

    Sheet nameString/Expression

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

    Default Value: [None]
    Example: Members

    Write header*Checkbox

    Select this checkbox to enable the Snap to write the header to the output.

    Default valueValue: Selected

    Ignore empty streamCheckbox

    Select this checkbox to write nothing to the output view in case no documents were received on the input view.

    If you deselect this checkbox, an empty array will be is 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

    Convert numeric strings to numbersCheckbox

    This property sets the behavior of the Snap when a value in the input document is a numeric string.

    Select this checkbox to enable the Snap to convert the value to a numeric-type cell.

    When you deselect this checkbox, the Snap sets the value to a string-type cell.

    Default Value: Selected

    Translate date and time typesCheckbox

    This property sets the behavior of the Snap when a value in the input document is a date and/or datetime type.

    Select this checkbox to enable the Snap to convert the date and time type values to Excel date numeric type with date format style.

    Default Value: Not selected

    Convert formula strings to formulas


    		Checkbox

    This field sets the behavior of the Snap when a value in the input document is a formula string.

    Select this checkbox to write string values that begin with an equal sign (=) as an Excel formula. If you want a value that begins with an equal sign (=) to not be written as a formula with this option selected, then the value must begin with a single quote (').

    Default value: Not selected

    Multiexcerpt include macro

    .

    Note

    If the Convert formula strings to formulas checkbox is selected, the Snap writes the formula, but will not evaluate it.

    Before you pass a worksheet as an input to the Excel Parser Snap, open the file in any spreadsheet application (such as Microsoft Excel or LibreOffice Calc), select the option to execute the full workbook, save the file, and then use this saved file in the Excel Parser Snap. Otherwise, the Excel Parser Snap will display a blank value or 0.


    Snap Executionpage


    		Dropdown listAnaplan Read
    Multiexcerpt include macro
    nameSnap_Execution_Introduced
    pageAnaplan Read

    Example

    Reading

    csv

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

    The following image shows a sample pipeline that reads two csv 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 sheetnamenamed sheet1 and input1 maps to sheet2. 
    Image Removed
    Example showing input mappingImage Added


    Insert excerpt
    Transform Snap Pack
    Transform Snap Pack
    nopaneltrue