Skip to main content
subbar214000
New Participant
Mar 14, 2024 11:47 AM UTC
Question

Export grid data to excel

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.

    5 replies

    stefanhelzle0001
    Brainy
    Mar 14, 2024 12:16 PM UTC

    The normal "Export Data Store Entity to Excel Smart Service" can do that. Did you consider that one?

    subbar214000
    New Participant
    Mar 14, 2024 12:30 PM UTC

    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?

    venkatrea696188
    Inspiring
    Mar 14, 2024 12:33 PM UTC

    Use loop and pass it as batches