Skip to main content
subbar214000
New Participant
March 14, 2024
Question

Export grid data to excel

  • March 14, 2024
  • 5 replies
  • 4 views

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
    March 14, 2024

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

    subbar214000
    New Participant
    March 14, 2024

    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
    March 14, 2024

    Use loop and pass it as batches