I want to export data from editable grid to excel file without storing data to database. How can I achieve this?
Discussion posts and replies are publicly visible
I usually do this by using . I use a dummy (empty) process report and use the Custom Cell Positions and Custom Cell Values to manually push to some values to it.
We are trying your approach but somehow unable to follow the the steps to get the result. could you please elaborate this more or share us some sample code.
Can you gives more details on which part you are having trouble with?
- Create a process which calls the Export to Excel Smart Service
- Add a script node that calls a an expression rule that returns 2 lists (positions and values)
- Configure the Export Process Report to Excel node with an empty process report and the positions and values
Positions and values should look like this
positions: {"A1", "A2"}
values: {"value 1", "value2"}