Excel Builder
Overview
Purpose
This manual describes the node Excel Builder. This node helps the developer prepare an excel file out of the node input DataFrame. The developer can set the columns data types and formats, he can also hide some columns if needed. Set some other settings for the excel file and sheet, like the font size and the sheet name, orientation.
After the developer saves these settings, each time this node runs, it will create an excel file with the data from the input DataFrame and apply these settings on it.
Configuration
Excel Builder displays the input in an excel like view. Including all column data types and formattings the user set.
In the following chapters we will describe how you can work with the Excel Builder and create your Excel file output.
Column Data Type
Set each column data type and format just like in Excel.
Click on the three dots next to the column header to open the column menu.
The Data Type dialog appears:
You can choose the General, Number, Text, Date, Currency or Custom data type. Then set the data type formatting as needed
When done, the selected columns display data formatted according to the chosen data type, just like in Excel.
Inputs
| Input | Data Type | Input Type | Description |
|---|---|---|---|
| Input | DataFrame | Single | Data bto be converted |
Outputs
| Output | Data Type | Collection | Description |
|---|---|---|---|
| Output | NodeFile | False | Excel file |
Properties
| Property | FlowDataType | Description |
|---|---|---|
| EXCEL_BLDR_FILE | JsonNode |
Hide Column
The Hide/Show Columns button in the toolbar above the table opens a dialog listing all columns. Check or uncheck any column to control its visibility in the Excel output.
Page Settings
Click on the Page Setup button on the top right side on the Excel Builder.
Here you can set the font size of the output. You may change the output excel sheet name and the orientation of the result file.
Reset
if you click on the Reset button on the top right corner of the Excel Builder, all the settings you have done will be reset and you can start over again and set your Excel output file.