IonToExcel

Convert an ION file into Excel.

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

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

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

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

Source file URI

Default UTF-8

The name of a supported character set

Default yyyy-MM-dd

Format to use for date

Default yyyy-MM-dd'T'HH:mm:ss.SSS[XXX]

Format to use for zoned datetime

Default true

Whether header should be written as the first line

Default Sheet

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

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.

Default HH:mm:ss[XXX]

Format to use for time

Default Etc/UTC

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

Default 0

The number of fetched rows

Format uri

Internal storage URI of the Excel file

​Ion​To​Excel

IonToExcel