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.