5.7. Excel Data Integration

Grids are often equipped with Excel data integration options, accessible through the kebab menu on the upper rightmost side. This integration refers to the 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.

There are some grids, however, that contain only a direct Export function.

• 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.