ExcelToIon

Read data from Excel into a row-wise ION-serialized format

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

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

Dynamic YES

Source file URI

Dynamic YES

Default UTF-8

The name of a supported character set

Dynamic YES

Default UNFORMATTED_VALUE

Possible Values

SERIAL_NUMBERFORMATTED_STRINGUNFORMATTED_VALUE

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

Possible values: SERIAL_NUMBER, FORMATTED_STRING

Dynamic YES

Default true

SubType string

Dynamic YES

The sheets title to be included

Dynamic YES

Default false

Dynamic NO

Default 0

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

Dynamic YES

Default UNFORMATTED_VALUE

Possible Values

FORMATTED_VALUEUNFORMATTED_VALUEFORMULA

Determines how values should be rendered in the output

Possible values: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA

Default 0

The number of fetched rows

SubType string

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: ""

​Excel​To​Ion

ExcelToIon