Overview
The Export to Excel feature allows you to export data from a Collection control configured with a dynamic data source to an Excel spreadsheet. You can enable or disable this feature from the App Designer editor.
Export to Excel is available for the following Collection Controls:
Enabling export
When configuring a Collection control with a dynamic data source, go to the third step (Customize) of the configuration wizard. There, you can enable one or both of the following export options:
•Allow download displayed data: Exports only the attributes selected for display in the App Designer editor, preserving their configured format (including concatenated properties).
•Allow download full data: Exports all attributes of the entity, regardless of display or format settings.
Once enabled, an export icon appears in the top-right corner of the control in the published app. Clicking the icon shows the available export options.
|
Only the enabled export types will be shown. |
Filters and search
Filters applied during design or after publishing affect the exported data. Searches made using a Collections Search control will also filter the records that are exported.
Export limits
By default, up to 10,000 rows can be exported. If the total number of records exceeds this value, only the first 10,000 rows are included.
|
If you need to increase this limit, submit a Support ticket to request a configuration update. |
Export behavior
•File name: For Data table controls, the export file name can be set in the App Designer editor. If not configured, or for other control types, the default file name is excelFile.
•Column headers: Column titles use the displayName of each property. For concatenated fields, the title corresponds to the first property.
•Date fields:
oIf configured as basic properties (e.g., in Data table controls), dates are exported in native date format.
oIf configured as advanced or concatenated, they are exported as plain text, using the format shown in the control.
|
Dates reflect the time zone of the user logged in to the App Designer editor. |
•Download process: When export starts, the export icon is replaced with a loader. A success message appears when the download completes.
Considerations
•Images and URLs are not exported:
oImages or file links configured in the Collection control are visible but will not be included in the exported Excel file.
oURLs are similarly excluded from the export.
oIf configured as basic attributes in Data table controls, the corresponding columns are excluded.
oIf configured as advanced or concatenated attributes, the reference is removed from the exported string.
•Each Excel cell supports up to 32,767 characters. Longer values are truncated.
Last Updated 5/8/2025 2:49:17 PM