Export to Excel with pivot table, how to?

arcullarcull Member Posts: 191
edited 2014-02-26 in NAV Three Tier
Hi all,

I wonder if anyone managed to create a pivot table when exporting data to excel in Nav 2013. We did it before by adding some custom functions in table Excel Buffer using automations. Now it is a bit different with dotnet, especially because nav does not use classic dotnet components like "Microsoft.Office.Interop.Excel.Workbook" but addins like "Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookWriter". Any sample code would be very helpfull, much thanks in advance.


Sign In or Register to comment.