Serialization ExcelToIon

Serialization ExcelToIon
Certified
Convert an Excel file to the Amazon ION format

Reads Excel (.xlsx) files in streaming mode. Each sheet is written to a separate ION file keyed by sheet name in the output map. Supports configurable value rendering and date/time output format.

yaml
type: io.kestra.plugin.serdes.excel.ExcelToIon

Examples

Convert an Excel file to the ION format.

yaml
id: excel_to_ion
namespace: company.team

tasks:
  - id: http_download
    type: io.kestra.plugin.core.http.Download
    uri: https://huggingface.co/datasets/kestra/datasets/raw/main/excel/Products.xlsx

  - id: to_ion
    type: io.kestra.plugin.serdes.excel.ExcelToIon
    from: "{{ outputs.http_download.uri }}"

Properties

from *string

Source file URI

Pebble expression referencing an Internal Storage URI e.g. {{ outputs.mytask.uri }}.

assets

Assets this task consumes as inputs or produces as outputs, for lineage tracking and the asset graph (Enterprise Edition). A flow declaring this property on a task is rejected in the open-source edition.

Definitions

io.kestra.core.models.assets.AssetsDeclaration

assetFailureBehaviorstring

Possible Values

IGNOREFAILWARN

Asset failure behavior

Behavior applied to the task state when a declared asset fails to render, emit, or be persisted (e.g. a lock conflict): FAIL escalates it to FAILED, WARN (default) warns it if it would otherwise succeed, IGNORE leaves the state untouched.

enableAutobooleanstring

Whether to auto-register assets referenced dynamically at runtime that are not statically declared in inputs or outputs.

inputsarray

The assets consumed as inputs.

io.kestra.core.models.assets.AssetIdentifier

id*string

Min length1

typestring

outputs

The assets produced as outputs.

io.kestra.plugin.ee.assets.Dataset

id*string

Min length1

Max length150

type*object

descriptionstring

displayNamestring

metadataobject

Default{}

namespacestring

Min length1

Max length150

io.kestra.plugin.ee.assets.File

id*string

Min length1

Max length150

type*object

descriptionstring

displayNamestring

metadataobject

Default{}

namespacestring

Min length1

Max length150

io.kestra.plugin.ee.assets.Table

id*string

Min length1

Max length150

type*object

descriptionstring

displayNamestring

metadataobject

Default{}

namespacestring

Min length1

Max length150

io.kestra.plugin.ee.assets.VM

id*string

Min length1

Max length150

type*object

descriptionstring

displayNamestring

metadataobject

Default{}

namespacestring

Min length1

Max length150

io.kestra.core.models.assets.External

id*string

Min length1

Max length150

type*object

descriptionstring

displayNamestring

metadataobject

Default{}

namespacestring

Min length1

Max length150

io.kestra.core.models.assets.Custom

id*string

Min length1

Max length150

type*string

Min length1

Custom asset type

descriptionstring

displayNamestring

metadataobject

Default{}

namespacestring

Min length1

Max length150

charset string

DefaultUTF-8

The name of a supported character set

dateTimeRender string

DefaultUNFORMATTED_VALUE

Possible Values

SERIAL_NUMBERFORMATTED_STRINGUNFORMATTED_VALUE

How dates, times, and durations should be represented in the output

Possible values: UNFORMATTED_VALUE (default — dates returned as ISO date strings), SERIAL_NUMBER (Excel numeric serial date), or FORMATTED_STRING (locale-formatted string).

header booleanstring

Defaulttrue

Whether the first row should be treated as the header

sheetsTitle array

SubTypestring

The sheets title to be included

skipEmptyRows booleanstring

Defaultfalse

Specifies if empty rows should be skipped

skipRows integer

Default0

Minimum>= 0

Number of lines to skip at the start of the file. Useful if a table has a title and explanation in the first few rows

valueRender string

DefaultUNFORMATTED_VALUE

Possible Values

FORMATTED_VALUEUNFORMATTED_VALUEFORMULA

Determines how values should be rendered in the output

Possible values: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA

Outputs

size integer

Default0

The number of fetched rows

uris object

SubTypestring

URIs of files serialized in ION format from specific sheets

Because this task can simultaneously read data from multiple sheets, it will parse them in the key-value pair format: sheet_name: file_uri. Therefore, to access data from Sheet1, use the output syntax: "{{ outputs.task_id.uris.Sheet1 }}"

Metrics

sheets counter

Number of sheets converted