exceltoion
Convert an Excel file into ION.
Convert an Excel file into ION.
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 }}.
charsetstring
UTF-8The name of a supported character set
dateTimeRenderstring
UNFORMATTED_VALUESERIAL_NUMBERFORMATTED_STRINGUNFORMATTED_VALUEHow dates, times, and durations should be represented in the output
Possible values: SERIAL_NUMBER, FORMATTED_STRING
headerbooleanstring
trueWhether the first row should be treated as the header
sheetsTitlearray
The sheets title to be included
skipEmptyRowsbooleanstring
falseSpecifies if empty rows should be skipped
skipRowsNon-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
valueRenderstring
UNFORMATTED_VALUEFORMATTED_VALUEUNFORMATTED_VALUEFORMULADetermines how values should be rendered in the output
Possible values: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA
Outputs
sizeinteger
0The number of fetched rows
urisobject
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: ""
Metrics
sheetscounter
Number of sheets converted
