ExcelToIon ExcelToIon

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

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

  • 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

  • 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

Was this page helpful?