Excel Multi Sheet Formatter

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.


Excel Multi Sheet Formatter

Snap views

View Description Examples of upstream and downstream Snaps
Input Document data to be formatted in to excel format.
Output This Snap provides the result of the formatted excel content in the binary output view. JSON Parser

File Writer Snap
Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the pipeline by choosing one of the following options from the When errors occur list under the Views tab. The available options are:

  • Stop Pipeline Execution Stops the current pipeline execution when an error occurs.
  • Discard Error Data and Continue Ignores the error, discards that record, and continues with the remaining records.
  • Route Error Data to Error View Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Snap settings

Legend:
  • Expression icon (): Allows using JavaScript syntax to access SnapLogic Expressions to set field values dynamically (if enabled). If disabled, you can provide a static value. Learn more.
  • SnapGPT (): Generates SnapLogic Expressions based on natural language using SnapGPT. Learn more.
  • Suggestion icon (): Populates a list of values dynamically based on your Snap configuration. You can select only one attribute at a time using the icon. Type into the field if it supports a comma-separated list of values.
  • Upload : Uploads files. Learn more.
Learn more about the icons in the Snap settings dialog.
Field / Field set Type Description
Label String

Required. Specify a unique name for the Snap. Modify this to be more appropriate, especially if more than one of the same Snaps is in the 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 name Dropdown list Select the name of the input view mapped to the sheet.

Default value: input0

Example: input1
Sheet name String/Expression Specify the name of the Excel sheet to map the input view data.This property accepts expressions to allow Pipeline parameters only.

Default value: None

Example: Members
Write CSV header Checkbox Select this checkbox to enable the Snap to write the header to the output.

Default status: Selected
Ignore empty stream Checkbox 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 is written to the output view in case no documents were received on the input view.

Default status: Deselected
Convert numeric strings to numbers Checkbox This property sets the behavior of the Snap when a value in the input document is a numeric string.
  • If selected, the Snap converts the value to a numeric-type cell.
  • If not selected, the Snap sets the value to a string-type cell.

Default status: Selected
Translate date and time types Checkbox This property sets the behavior of the Snap when a value in the input document is a date and/or datetime type.

If selected, the Snap does not convert the date and/or datetime types to text/string and instead converts it to Excel date numeric type with date format style.

Default status: Deselected
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 (').
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.

Default status: Deselected
Snap execution Dropdown list
Choose one of the three modes in which the Snap executes. Available options are:
  • Validate & Execute: Performs limited execution of the Snap and generates a data preview during pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during pipeline runtime.
  • Execute only: Performs full execution of the Snap during pipeline execution without generating preview data.
  • Disabled: Disables the Snap and all Snaps that are downstream from it.

Default value: Validate & Execute

Example: Execute only