IonToExcel
Read an ION-serialized file and transform it to an Excel file
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 }}"
Dynamic YES
Source file URI
Dynamic YES
Default UTF-8
The name of a supported character set
Dynamic YES
Default yyyy-MM-dd
Format to use for date
Dynamic YES
Default yyyy-MM-dd'T'HH:mm:ss.SSS[XXX]
Format to use for zoned datetime
Dynamic YES
Default true
Dynamic YES
Default Sheet
The sheet title to be used when writing data to an Excel spreadsheet
Dynamic YES
Default true
Dynamic YES
Default HH:mm:ss[XXX]
Format to use for time
Dynamic YES
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