.. _auto_excel_to_database:

*CONVERTS EXCELS TO DATABASE*
=============================

Ingests one or more sheets from an Excel file and persists the contents as a named database (dataset) within the platform. Supports a generic layout as well as a structured FCA Powertrain format. Use this worker whenever tabular Excel data needs to be promoted to a queryable platform database.

When to use
-----------

Tagged: ``database``, ``excel``, ``fca_powertrain``, ``files``, ``ingest``, ``tabular``.

Inputs
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Database Name
     - database_name
     - text
     - —
     - ✓
     - Unique name for the target platform database that will be created or overwritten; must be a non-empty string (e.g. 'my_test_results').
   * - Database Description
     - database_desc
     - text
     - —
     - 
     - Optional human-readable description stored alongside the database to explain its contents or provenance; leave blank if no annotation is needed.
   * - Excel File
     - excel_file
     - file
     - —
     - ✓
     - The .xlsx / .xls file whose sheet(s) will be parsed and loaded; must be a valid Excel workbook uploaded via the file picker.
   * - Excel Format
     - excel_format
     - select
     - generic
     - 
     - Parsing schema to apply: 'generic' (default) treats every sheet as flat tabular data; 'fca_powertrain' applies the FCA Powertrain-specific column mapping and header conventions.

Outputs
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - Label
     - ID
     - Type
     - Description
   * - Records
     - records
     - dataset
     - Platform dataset containing all rows ingested from the Excel file, typed and structured according to the chosen format, ready for downstream querying or transformation.

Disciplines
-----------

- data.dataset.ingest
- data.io.excel

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>platform</code> schema. Worker id: <code>excel_to_database</code>. Schema hash: <code>590e6d125f2d</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>