IonToExcel

Convert an ION file into Excel.

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

Examples

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

Properties

from *stringobject

Source file URI

charset string

Default UTF-8

The name of a supported character set

dateFormat string

Default yyyy-MM-dd

Format to use for date

dateTimeFormat string

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

Format to use for zoned datetime

header booleanstring

Default true

Whether header should be written as the first line

sheetsTitle string

Default Sheet

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

styles booleanstring

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 string

Default HH:mm:ss[XXX]

Format to use for time

timeZoneId string

Default Etc/UTC

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

Outputs

size integer

Default 0

The number of fetched rows

uri string

Format uri

Internal storage URI of the Excel file

​Ion​To​Excel

IonToExcel