5.7. Excel Data Integration

Grids are often equipped with data integration options, accessible through the kebab menu on the upper rightmost side. These options facilitate the direct interaction between the grid and Microsoft Excel.

1. Download Excel Template: This option allows users to generate an Excel template of the grid—that is, an Excel sheet with the grid’s column headers.
   

   **The primary purpose of this template is to facilitate data entry and streamline the import process. Once it has been downloaded, users can fill the template with the required data and import it into the grid.

2. Import from Excel: This option allows users to import data from an Excel sheet into the grid.
   • If selected, a file dialog will appear, enabling users to select the appropriate file from their local system.
     

     !!Only the data inside the columns of the worksheet will be imported. If a control is not listed as a column, it cannot be imported into the grid.

3. Export to Excel: This option allows users to export the grid data to Excel.

   • If selected, an Excel file containing the grid’s contents will be automatically downloaded to the user’s device.

Tables, in contrast, when equipped with data integration support, allow only for direct export functionality.

• Export All Data to Excel ( ): This button allows users to export the grid data to Excel.

  • If selected, an Excel file containing the grid’s contents will be automatically downloaded to the user’s device.