I want to use RecordListToExcel but my record list is very complex

Greetings all,

I want to use RecordListToExcel but my record list is very complex (please see attached image). How can I put all the details of my record list into an Excel?

Thanks

Hi YS,

Since Excel is as simple as a flat table, you can do two things.

1. You can flatten your structure to a flat structure.

2. You can create an excel with multiple tabs (AdvancedExcel) where each tab contains a layer of the structure.

Kind regards,

Remco Dekkinga


Solution

Hi,

just to complement the Remco informations: Advance Excel

Cheers

Solution

Hi YS,

Apart from Remco's answer, you need to think of how you want to include what's basically a tree-view (lists within lists) in an Excel file.Once you know, you can follow Remco's advise of "flattening" the data and export it.