IonToExcel
yaml
type: "io.kestra.plugin.serdes.excel.iontoexcel"
Examples
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 }}"
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 *Requiredstringobject
charset string
Default
UTF-8
dateFormat string
Default
yyyy-MM-dd
dateTimeFormat string
Default
yyyy-MM-dd'T'HH:mm:ss.SSS[XXX]
header booleanstring
Default
true
sheetsTitle string
Default
Sheet
styles booleanstring
Default
true
timeFormat string
Default
HH:mm:ss[XXX]
timeZoneId string
Default
Etc/UTC
Outputs
size integer
Default
0
uri string
Format
uri