Exports multiple inputs as separate tabs to an Excel Workbook stored in the current workspace.
Information at a Glance
Category
|
Tools
|
Data source type
|
HD
|
Sends output to other operators
|
No
|
Data processing tool
|
n/a
|
Note: The Export to Excel (HD) operator is for Hadoop data only. For database data, use the
Export to Excel (DB) operator.
Export to Excel (HD) supports tabular HDFS inputs. The workbook sheet names are the (cleaned) input operator names, sorted alphabetically.
Input
Tabular data sets from preceding operators. Avro and Parquet inputs are supported.
- Bad or Missing Values
- Null and empty values in the inputs are converted to blank cells in the workbook.
Restrictions
If the workbook size is above the
Team Studio work file size limit set for your instance, the operator fails and reports an error with the estimated file size and instance limitation value.
This setting is configurable in the
Team Studio configuration properties in the file
alpine.conf.
- custom_operator.excel_export.max_mb_input_size_alpine_server for Export to Excel (HD), maximum 30MB.
- custom_operator.excel_reader.max_mb_input_stream for Excel Reader (DB and HD), maximum 30MB.
Configuration
Parameter
|
Description
|
Notes
|
Any notes or helpful information about this operator's parameter settings. When you enter content in the
Notes field, a yellow asterisk is displayed on the operator.
|
Output Workbook Name
|
Specify the name of the workbook stored in the
Team Studio Workspace.
|
Create New Version if Exists
|
true - A new version of the workbook is created in the workspace, and previous versions are still accessible through the work file version-control button.
false - If a work file of the same name already exists, the operator fails with an output error message that notifies the user of the existing work file.
|
Output
- Visual Output - Summary
-
- Data Output
- None. This is a terminal operator.
Copyright © Cloud Software Group, Inc. All rights reserved.