Interface to excel

Question

I want to export data from editable grid to excel file without storing data to database. How can I achieve this?

Mathieu Drouin · Answer

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.

Mathieu Drouin · Answer

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: &#123;"A1", "A2"&#125; 
 values: &#123;"value 1", "value2"&#125;

Mike Schmitt · Answer

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.