ExcelToIon
Read data from Excel into a row-wise ION-serialized format
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
The name of a supported character set
How dates, times, and durations should be represented in the output
Possible values: SERIAL_NUMBER, FORMATTED_STRING
The sheets title to be included
Number of lines to skip at the start of the file. Useful if a table has a title and explanation in the first few rows
Determines how values should be rendered in the output
Possible values: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA
The 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: ""