IonToExcel
Read an ION-serialized file and transform it to an Excel file
type: "io.kestra.plugin.serdes.excel.IonToExcel"Download a CSV file and convert it to the Excel file format.
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.
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 }}"
YESSource file URI
YESUTF-8The name of a supported character set
YESyyyy-MM-ddFormat to use for date
YESyyyy-MM-dd'T'HH:mm:ss.SSS[XXX]Format to use for zoned datetime
YEStrueWhether header should be written as the first line
YESSheetThe sheet title to be used when writing data to an Excel spreadsheet
YEStrueWhether 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.
YESHH:mm:ss[XXX]Format to use for time
YESEtc/UTCTimezone to use when no timezone can be parsed on the source.
0The number of fetched rows
uriInternal storage URI of the Excel file