Skip to main content
A
anithad2326
September 15, 2025
Question

How to export the editable grid data into excel

  • September 15, 2025
  • 2 replies
  • 0 views

This is my usecase. i have editable grid of data  and also providing user to do the (custom) filter and sorting. But now user want the export those data into excel.

we have used EXPORT DSE to Excel smart service to do that. But here the challenges is user applied sort is not working when we export the data.

I don't know how to configure that. Can anyone help me here.

2 replies

shubhama926776
shubhama926776
September 15, 2025

There are multiple ways to handle this but i would recommend,

Create Staging table then, Collect user interface actions like sorting and filtering, and use those values to create a dynamic expression for querying and writing data to the staging table using PM. Then, use Export Data Store Entity to Excel to retrieve data from the staging table, and delete the same data afterward.

Make sure that if you have concurrent user sessions, use userId as an identifier to export and delete the correct data for each user.

mikes0011
mikes0011
Brainy
September 15, 2025

My current recommendation is the newer plug-in, Export JSON to Excel.  It sidesteps a lot of the artificial limitations of DSE to Excel (sorting, lack of support for a base template, etc), and doesn't require the painful workarounds like creating a staging table, etc.  You can just query your data, do whatever local transformations on it you'd like, wrap it up as JSON, then pass it into the node.

Terms & ConditionsAccessibility statement