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
Would a CSV file work for you?
No, requirement is to export data to excel.
I do not know of any way. Maybe others can help.
Why dont you try creating a temp table and store these data into the table and then use export dse to excel. IS there any specific reason you dont want to write to db?
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"}
Use the "CDT to Excel" node from the Excel Tools plug-in. Create a generic CDT consisting of X number of plaintext fields (where X represents the maximum number of columns you might need). Cast your data into this CDT type and pass it into a process instance using a!startProcess. Should be fairly easy.