Generate Excel File Using 2 sheets in it

Question

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 requirement 2.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

Harsha Sharma · Accepted Answer

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.

Harsha Sharma · Answer

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

Generate Excel File Using 2 sheets in it

Top Replies