IonToExcel
Convert an ION file into Excel.
Convert an ION file into Excel.
Convert an ION file into Excel.
type: "io.kestra.plugin.serdes.excel.IonToExcel"Examples
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 }}"
Properties
from*Requiredstringobject
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
kestrafor internal storage files,filefor host local files, andnsfilefor namespace files. - A JSON String that will then be serialized either as a single item or a list of items.
charsetstring
UTF-8The name of a supported character set
dateFormatstring
yyyy-MM-ddFormat to use for date
dateTimeFormatstring
yyyy-MM-dd'T'HH:mm:ss.SSS[XXX]Format to use for zoned datetime
headerbooleanstring
trueWhether header should be written as the first line
sheetsTitlestring
SheetThe sheet title to be used when writing data to an Excel spreadsheet
stylesbooleanstring
trueWhether 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.
timeFormatstring
HH:mm:ss[XXX]Format to use for time
timeZoneIdstring
Etc/UTCTimezone to use when no timezone can be parsed on the source.
Outputs
sizeinteger
0The number of fetched rows
uristring
uriInternal storage URI of the Excel file
Metrics
recordscounter
Number of records converted
