Serialization IonToExcel

Serialization IonToExcel

Certified

Convert an ION file to the Excel format

Accepts a single ION file URI or a map of sheet names to ION file URIs to write multiple sheets into one workbook. Dates and temporal values are formatted automatically when styles is enabled.

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

Structured data items, either as a map, a list of map, a URI, or a JSON string.

Structured data items can be defined in the following ways:

  • A single item as a map (a document).
  • A list of items as a list of maps (a list of documents).
  • A URI, supported schemes are kestra for internal storage files, file for host local files, and nsfile for namespace files.
  • A JSON String that will then be serialized either as a single item or a list of items.
DefaultUTF-8

The name of a supported character set

Defaultyyyy-MM-dd

Format to use for date

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

Format to use for zoned datetime

Defaulttrue

Whether header should be written as the first line

Reference (ref) of the pluginDefaults to apply to this task.

DefaultSheet

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

Defaulttrue

Whether styles should be applied to format values

Excel is limited to 64,000 styles per document. Disable this option when writing many date values to avoid exceeding that limit.

DefaultHH:mm:ss[XXX]

Format to use for time

DefaultEtc/UTC

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

Default0

The number of fetched rows

Formaturi

Internal storage URI of the Excel file

Number of records converted

More Plugins in this Category

Core Plugins and tasks
Core Plugins and tasks

Tasks that provide Kestra's built-in orchestration, I/O, and observability capabilities.

Core

122 tasks

398 blueprints

Liquibase
Liquibase

Tasks that run Liquibase change management commands.

Data

2 tasks