Export to Excel (HD)

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.

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.