ExcelToIon

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

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

Examples

Convert an Excel file to the Ion format.

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

• Type: string
• Dynamic: ✔️
• Required: ✔️
• Min length: 1

Source file URI

charset

• Type: string
• Dynamic: ❌
• Required: ❌
• Default: UTF-8

The name of a supported character set

dateTimeRender

• Type: string
• Dynamic: ❌
• Required: ❌
• Default: UNFORMATTED_VALUE
• Possible Values:
  • SERIAL_NUMBER
  • FORMATTED_STRING
  • UNFORMATTED_VALUE

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

Possible values: SERIAL_NUMBER, FORMATTED_STRING

header

• Type: boolean
• Dynamic: ❌
• Required: ❌
• Default: true

Whether the first row should be treated as the header

sheetsTitle

• Type: array
• SubType: string
• Dynamic: ❌
• Required: ❌

The sheets title to be included

skipEmptyRows

• Type: boolean
• Dynamic: ❌
• Required: ❌
• Default: false

Specifies if empty rows should be skipped

skipRows

• Type: integer
• Dynamic: ❌
• Required: ❌
• 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

valueRender

• Type: string
• Dynamic: ❌
• Required: ❌
• Default: UNFORMATTED_VALUE
• Possible Values:
  • FORMATTED_VALUE
  • UNFORMATTED_VALUE
  • FORMULA

Determines how values should be rendered in the output

Possible values: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA

Outputs

size

• Type: integer
• Required: ❌
• Default: 0

The number of fetched rows

uris

• Type: object
• SubType: string
• Required: ❌

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

Definitions