export functionality I will be having 10,000 records so I don't want to export as a single Excel sheet I need to export dynamic sheets each sheet having 5,000 records only.
So please give me some tips on how can we implement this scenario.
Discussion posts and replies are publicly visible
The normal "Export Data Store Entity to Excel Smart Service" can do that. Did you consider that one?
Okay, but I need to split the rows data dynamically ex: 1 sheet I want 5000 records, and for 2nd sheet I want 5000 like that splitting. So how to achieve this scenario?
Use loop and pass it as batches
Thanks, Venky ..It's perfectly working fine
You can simply do that with the general export to data store entity to excel smart service. Have a pv for your sheet number parameter and configure it in a script task. The initial batch would be 5000 and the increment will be done in the script and saved in the data variable. an additional pv for the counter/sheet number.