Import Excel (DB)
Imports an Excel workbook sheet (or a portion of the sheet) as a database table.
Information at a Glance
Category | Load Data |
Data source type | DB |
Sends output to other operators | Yes1 |
Data processing tool | n/a |
The Excel workbook can be stored in the current workspace.
Formula cells, styles, dates, currencies, percentages, and so on are supported, and are parsed as numeric values. Non-tabular data such as images and pivot tables are skipped. Hidden columns and protected sheets are parsed as normal.
Restrictions
Excel files are read on the Team Studio server. Depending on the memory available on your instance, loading very large Excel files on this server might require a large amount of memory and cause out-of-memory issues. For more information, see Apache POI limitations at https://poi.apache.org/spreadsheet/limitations.html.
Team Studio uses the configuration parameter custom_operators, set in the alpine.conf file, to avoid loading files that are too large. If the Excel file is bigger than this limit, it does not load and an error message is displayed. The default value is 30.0 (MB). The administrator of your Team Studio instance can modify the default value.