Using Form Builder
This action creates an entity list in the current context from the content of a provided XLSX file. You can find the number of loaded entities in the
This creates an entity that can be used ONLY in the current context. This does not create a Plant an App Entity.
Typical Use Cases
- Load values from an Excel file provided by a user in a File Upload form field and then use Execute Actions on Entity List to run the same actions on each item in the uploaded file.
- Use in
Automationto Load values from an Excel file already on the server and then use Execute Actions on Entity List to run the same actions on each item in the file.
Don't use it to
- Take actions on the provided Excel file such as renaming it. Use File Management actions instead.
- Serialize data to create an Excel file. Use the
Serialize to Excel from entity list XLSXaction instead.
|Execute Actions on Entity List||Execute a list of actions on each item in the specified context entity. Use this to process the items loaded in the entity created.|
|Extend Entity||Extends an entity with new properties.|
Input Parameter Reference
The parameters unique to this action are listed below. Review the common parameters for all actions here.
|File Path||Path to the Excel (XLSX) file. If using on a form and one or more ||Yes||Yes|
|Entity Name||Provide a name for the entity being created. This name can be used in the Execute Actions on Entity List action to reference the items in the entity using ||Yes||Yes|
|Include All Fields||Select this option to include all columns in the provided Excel file.||No||No|
|Use first row as column names||Use the first row of the Excel file as column names. If this option is not checked the entity will be assigned 0 based index column names as ||No||No|
|Properties||Map columns from the Excel file to properties of the entity.||Yes||None Specified||No|
|Sheet Name||Name of the sheet in the Excel file to use.||Yes||Yes|
|Start Row||Specify the first row to be included in the entity. If left empty, the entity will be created starting with the first row of the sheet.||Yes||No|
|End Row||Specify the last row to be included in the entity. If left empty the entity will include the last row.||Yes||No|
|On Error||Specify a list of actions to run on error. Otherwise, an error message is returned which will contain the underlying error if debug mode is on.||Yes||None Specified||No|