By default, loading data from Excel only handles strings.


To handle date, number, etc. in a mapping with an Excel spreadsheet as source, the following functions can be used to convert data type on load:

- to_number()
- to_date()
- to_timestamp()
- to_time()
- to_boolean()


For example :


Make sure the execution location is on "Source".