ExcelToIon
Convert an Excel file into ION.
type: "io.kestra.plugin.serdes.excel.ExcelToIon"Examples
Convert an Excel file to the Ion format.
id: excel_to_ion
namespace: company.team
tasks:
- id: http_download
type: io.kestra.plugin.core.http.Download
uri: https://huggingface.co/datasets/kestra/datasets/raw/main/excel/Products.xlsx
- id: to_ion
type: io.kestra.plugin.serdes.excel.ExcelToIon
from: "{{ outputs.http_download.uri }}"
Properties
from *Requiredstring
Source file URI
Pebble expression referencing an Internal Storage URI e.g. {{ outputs.mytask.uri }}.
charset string
UTF-8The name of a supported character set
dateTimeRender string
UNFORMATTED_VALUESERIAL_NUMBERFORMATTED_STRINGUNFORMATTED_VALUEHow dates, times, and durations should be represented in the output
Possible values: SERIAL_NUMBER, FORMATTED_STRING
header booleanstring
trueWhether the first row should be treated as the header
sheetsTitle array
The sheets title to be included
skipEmptyRows booleanstring
falseSpecifies if empty rows should be skipped
skipRows Non-dynamicinteger
0 >= 0Number of lines to skip at the start of the file. Useful if a table has a title and explanation in the first few rows
valueRender string
UNFORMATTED_VALUEFORMATTED_VALUEUNFORMATTED_VALUEFORMULADetermines how values should be rendered in the output
Possible values: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA
Outputs
size integer
0The number of fetched rows
uris object
URIs of files serialized in ION format from specific sheets
Because this task can simultaneously read data from multiple sheets, it will parse them in the key-value pair format: sheet_name: file_uri. Therefore, to access data from Sheet1, use the output syntax: ""