Skip to main content
Version: Next

Excel To Cloud Objects

Converts an Excel file to a Cloud Object / Cloud Object List

Description​

Convert an Excel file to a Cloud Object or a Cloud Object List. Each line of the Excel file will be converted into a single Cloud Object instance matching the Data Type input.

The function assumes that the headers in the Excel file are equal to the property names of the Data Type. If you need to convert between them, take a look at Map JSON to Object

Example​

(For readability purposes, the Excel File is represented as CSV, and the Cloud Object List is represented as a JSON)


Excel file:

firstname,lastname
john,doe
jane,doe

Resulting Cloud Object List (property names must match Excel headers)

[
  {"firstname":"john", "lastname":"doe"},
  {"firstname":"jane", "lastname":"doe"}
]

Inputs​

  • excel file (File): The Excel file
  • data type (Type): The Data Type of the Cloud Objects to be instantiated
  • sheet name (String): the name of the sheet in the excel file (defaults to the first one)
  • persist (Boolean)
  • range (String): A specific range within the Excel sheet to read from. If not specified, the entire sheet is processed.
    Ex.: 'A1:F4'

Outputs​

  • cloud objects (List): The resulting Cloud Object / Cloud Object List
  • Error Flow (Error Flow): Error Flow