IonToExcel

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

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

Examples

Download a CSV file and convert it to the Excel file format.

id: ion_to_excel
namespace: company.team

tasks:
  - id: http_download
    type: io.kestra.plugin.core.http.Download
    uri: https://huggingface.co/datasets/kestra/datasets/raw/main/csv/products.csv

  - id: convert
    type: io.kestra.plugin.serdes.csv.CsvToIon
    from: "{{ outputs.http_download.uri }}"

  - id: to_excel
    type: io.kestra.plugin.serdes.excel.IonToExcel
    from: "{{ outputs.convert.uri }}"

Download CSV files and convert them into an Excel file with dedicated sheets.

id: excel
namespace: company.team

tasks:
  - id: dataset1
    type: io.kestra.plugin.core.http.Download
    uri: https://huggingface.co/datasets/kestra/datasets/raw/main/csv/products.csv

  - id: dataset2
    type: io.kestra.plugin.core.http.Download
    uri: https://huggingface.co/datasets/kestra/datasets/raw/main/csv/fruit.csv

  - id: convert1
    type: io.kestra.plugin.serdes.csv.CsvToIon
    from: "{{ outputs.dataset1.uri }}"

  - id: convert2
    type: io.kestra.plugin.serdes.csv.CsvToIon
    from: "{{ outputs.dataset2.uri }}"

  - id: write
    type: io.kestra.plugin.serdes.excel.IonToExcel
    from:
      Sheet_1: "{{ outputs.convert1.uri }}"
      Sheet_2: "{{ outputs.convert2.uri }}"

Properties

from

• Type:
  • string
  • object
• 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

header

• 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: Etc/UTC

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

Outputs

size

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

The number of fetched rows

uri

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

Internal storage URI of the Excel file