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 }}.

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

pluginDefaultsRef string

Reference (ref) of the pluginDefaults to apply to this task.

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