Skip to main content

Container Excel

Used when you want to create a container from a specific excel file that was uploaded to a connected media source.

Available properties:

PropertyDescription 
NameName of the excel container 
TranslationName of the excel container in different languages 
DatasourceData source where the excel file is stored 
ResourceName of the excel file with extension 
OptionsGeneral settings about the excel file:
  • Password: The password of the file if secured
  • Worksheet: Which worksheet to query
  • StartRow: Where to start reading data from
  • RangeName: If you want to select the range
  • HasHeaders: Skip first row if table already has headers
 
+Add new column into the table 
👁Preview the data
🌐Set translation in different languages 
RelationsAdd new relations to different tables, available relations are:
  • One to one
  • Many to one
  • Many to many