ExcelToIon ExcelToIon

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

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

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
  • Dynamic:
  • Required:
  • Default: 0

The number of fetched rows

uris

  • Type: object
  • SubType: string
  • Dynamic:
  • 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: "null"