PluginsSerializationTasksExcelIonToExcel

IonToExcel​Ion​To​Excel

IonToExcel IonToExcel

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

Read an ION-serialized file and transform it to an Excel file

Properties

from

  • Type: string
  • Dynamic: ✔️
  • Required: ✔️

Source file URI

charset

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

The name of a supported character set

dateFormat

  • Type: string
  • Dynamic: ✔️
  • Required: ❌
  • Default: yyyy-MM-dd

Format to use for date

dateTimeFormat

  • Type: string
  • Dynamic: ✔️
  • Required: ❌
  • Default: yyyy-MM-dd'T'HH:mm:ss.SSS[XXX]

Format to use for zoned datetime

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

Whether header should be written as the first line

sheetsTitle

  • Type: string
  • Dynamic: ❌
  • Required: ❌
  • Default: Sheet

The sheet title to be used when writing data to an Excel spreadsheet

styles

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

Whether styles should be applied to format values

Excel is limited to 64000 styles per document, and styles are applied on every date, removed this options when you have a lots of values.

timeFormat

  • Type: string
  • Dynamic: ✔️
  • Required: ❌
  • Default: HH:mm:ss[XXX]

Format to use for time

timeZoneId

  • Type: string
  • Dynamic: ✔️
  • Required: ❌
  • Default: Europe/Paris

Timezone to use when no timezone can be parsed on the source.

Outputs

size

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

The number of fetched rows

uri

  • Type: string
  • Dynamic: ❓
  • Required: ❌
  • Format: uri

Internal storage URI of the Excel file