Hello Everyone,
I have a requirement to generate excel file contains 2 sheets in it.
In my case there is already one file generating using Export DSE to Excel, below approaches i tried but no luck. Can anyone help me on this
Approaches:-
1.2 DSE nodes with merge excel documents but this won't suffice my requirement2.Used Combine excel sheets plugin but this is not working as expected getting error as Invalid Null arguments & output of this node have integer type
Hoping to get responses from you guys thanks
Discussion posts and replies are publicly visible
In your first approach instead of Merge Excel you need to configure the Sheet Number and 'Document to Update' parameters efficiently within the 2 DSE to Excel nodes.
In first Export Data store entity to excel node put the sheet number as 1. Store the output doc from this node in a pv.
In 2nd Export Data store entity to excel node you need to take care of two things
1. 'Document to Update' should be the document you get as an output of 1st Export Data store entity to excel node.
2. Sheet number should be 2
Now, the output document after 2nd Export Data store entity to excel will have 2 sheets with respective details from entity.
Hello Harsha,
Thanks for the response & this approach i tried & working fine but if i start the process from UI & enabled activity chaining i am getting latest sheet in the file instead it should get 2 sheets what could be the issue i feel due to activity chaining its not updating properly & i have added dummy script between 2 nodes still no luck.
If I understood correctly, the process is generating final document properly with 2 sheets in the excel but interface is receiving just latest sheet? If yes then can you share the a!startprocess () configuration in interface as well as the process model design. May be the variable referred in onSuccess attribute of start process in UI is not set properly