ExcelToIon
Convert an Excel file into ION.
type: "io.kestra.plugin.serdes.excel.ExcelToIon"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 }}"
Source file URI
Pebble expression referencing an Internal Storage URI e.g. {{ outputs.mytask.uri }}.
UTF-8The name of a supported character set
UNFORMATTED_VALUESERIAL_NUMBERFORMATTED_STRINGUNFORMATTED_VALUEHow dates, times, and durations should be represented in the output
Possible values: SERIAL_NUMBER, FORMATTED_STRING
trueWhether the first row should be treated as the header
The sheets title to be included
falseSpecifies if empty rows should be skipped
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
UNFORMATTED_VALUEFORMATTED_VALUEUNFORMATTED_VALUEFORMULADetermines how values should be rendered in the output
Possible values: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA
0The number of fetched rows
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: ""