IonToExcel
IonToExcel
yaml
type: "io.kestra.plugin.serdes.excel.IonToExcel"
Read an ION-serialized file and transform it to an Excel file
Properties
from
- Type: string
- Dynamic: ✔️
- Required: ✔️
Source file URI
charset
- Type: string
- Dynamic: ❌
- Required: ❌
- Default:
UTF-8
The name of a supported character set
dateFormat
- Type: string
- Dynamic: ✔️
- Required: ❌
- Default:
yyyy-MM-dd
Format to use for date
dateTimeFormat
- Type: string
- Dynamic: ✔️
- Required: ❌
- Default:
yyyy-MM-dd'T'HH:mm:ss.SSS[XXX]
Format to use for zoned datetime
header
- Type: boolean
- Dynamic: ❌
- Required: ❌
- Default:
true
Whether header should be written as the first line
sheetsTitle
- Type: string
- Dynamic: ❌
- Required: ❌
- Default:
Sheet
The sheet title to be used when writing data to an Excel spreadsheet
styles
- Type: boolean
- Dynamic: ❌
- Required: ❌
- Default:
true
Whether 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.
timeFormat
- Type: string
- Dynamic: ✔️
- Required: ❌
- Default:
HH:mm:ss[XXX]
Format to use for time
timeZoneId
- Type: string
- Dynamic: ✔️
- Required: ❌
- Default:
Europe/Paris
Timezone to use when no timezone can be parsed on the source.
Outputs
size
- Type: integer
- Dynamic: ❓
- Required: ❌
- Default:
0
The number of fetched rows
uri
- Type: string
- Dynamic: ❓
- Required: ❌
- Format:
uri
Internal storage URI of the Excel file