Excel export

Hi everyone!

I’ve to export some data from a Nav Table to an Excel File. My data must be sorted by a Navision field called Location Code.

My question is: Is it possible to create a different sheet by Location Code? I’m not sure if it’s possible to do this…


I would just use the Excel Automation and do something like this. Do a loop and everytime there is a new location code add a sheet.

xlWorkSheet3 := xlApp.ActiveSheet;
xlWorkSheet3.Name := “Location Code”;