[Advanced Excel] Multiple aggregates in multiple sheets

[Advanced Excel] Multiple aggregates in multiple sheets

  
Forge Component
(37)
Published on 8 Oct (11 days ago) by Hanno
37 votes
Published on 8 Oct (11 days ago) by Hanno

I'm trying to create an Excel file with multiple sheets. And each sheet contains records from different aggregates. Is it possible to achieve this? If so, where can i find an example?

Hi b_pal

Yes, it is possible. Unfortunately, there is no example at the moment.

Hanno wrote:

Hi b_pal

Yes, it is possible. Unfortunately, there is no example at the moment.

Well can you explain how to do it then?


I figured out how to make different worksheets. Now how do i export each aggregate to each sheet? Can i export all the data at once or do i have to iterate through each item in the list?

b_pal wrote:

I figured out how to make different worksheets. Now how do i export each aggregate to each sheet? Can i export all the data at once or do i have to iterate through each item in the list?

Hi, I'm trying to achieve the same thing. Have you figured it out? Can you please explain how to create multiple sheets?



Hi b_pal,


If you have a look at the explanation of version 1.2.7 of this extension, you can see how I export three tables to three separate worksheets of one Excel workbook.