On this Page
Table of Contents | ||||
---|---|---|---|---|
|
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.
| |||||||||||||
Prerequisites: | None. | |||||||||||||
Support and limitations: | NoneDoes not work in Ultra Pipelines. | |||||||||||||
Account: | Accounts are not used with this Snap. | |||||||||||||
Views: |
| |||||||||||||
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. | |||||||||||||
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 | |||||||||||||
|
|
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 | ||||||
---|---|---|---|---|---|---|
|