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
YESSource file URI
Dynamic
YES Default
UTF-8The name of a supported character set
Dynamic
YES Default
yyyy-MM-ddFormat 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
SheetThe 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/UTCTimezone to use when no timezone can be parsed on the source.
Default
0The number of fetched rows
Format
uriInternal storage URI of the Excel file