Export to Excel (DB)

Exports multiple inputs as separate tabs to an Excel Workbook stored in the current workspace.

Information at a Glance

Category Tools
Data source type DB
Sends output to other operators No
Data processing tool n/a
Note: The Export to Excel (DB) operator is for database data only. For Hadoop data, use the Export to Excel (HD) operator.

Export to Excel (DB) supports database tables as inputs. The workbook sheet names are the (cleaned) input operator names, sorted alphabetically.

Input

Tabular data sets from preceding operators.

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.db_table_max_cells for Export to Excel (DB), maximum 50000000, or 50 million cells (1M rows * 50 columns).
  • 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 (the default) - 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.

Example