In Constellation, our table is sourced from a non‑queryable data page that uses an activity as its source. Since the standard “Export to Excel” option is not available for non‑queryable data pages, how can we implement an export to Excel feature for such tables?
vPega 25.1
The built-in Export to Excel option works only for queryable data pages. Since your table is backed by a non-queryable data page sourced through an activity, that OOTB option will not be available.
The recommended workaround is either to refactor the source into a queryable data page backed by a Report Definition, or to implement a custom export using an Excel template plus pxGenerateExcelFile from an activity. That custom approach is commonly used when the data page must remain activity-based
Export to Excel is ONLY available if the source is Report definition as of 25.1 version. The alternative could be DX component to export it to excel (input will be the data page for the DX component)
The pxGenerateExcelFile approach that @RaviChandra mentioned is covered here: How to Export Data to Excel with Multiple Sheets in Pega using pxGenerateExcelFile - General - Pega Forums