2.2.10.18 Excel Drop

The control is FAB specific to allow drag and drop of excel files and set the data to a table control

Properties of Excel Drop

Id - unique identifier of the control
Title - Text displayed in the control before an excel file has been dropped
From Sheet - this is the Excel Worksheet name where the control will look for the data. Take note that the Excel Worksheet should have the first row as a heading/column names and these should exactly correspond to the Bound Field names of the Table Cells
To Table Bound Field - The Table Control Bound Field where the data will be assigned.
OnDrop - optional Javascript Function that will be called during the event of dropping an Excel File into the control
Width - set the width of the control (e.g 50px)
Height - set the height of the control (e.g 100px).
Visible - set a boolean value or a variable with type boolean from the Model to control the visibility property

Step-by-step guide

How to add a HTML

Right click on a Page, Form Element or from any elements under Add Layout and select Add Excel Drop
An Excel Drop control has been added

Related articles