Export to Excel with pivot table, how to?

arcull

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.

Torben_R.

Take a look at codeunit 424 Export Analysis View.

arcull

Thanks Torben, but export in CU 424 is all done the old way (via automations), and we would like to avoid them in nav 2013, because of issues like this http://www.mibuso.com/forum/viewtopic.php?f=32&t=60520. If you can suggest alternative solution, it would be great

Jut

Hi Arcull,

A reasonable alternative is to use Power Pivot in combination with OData-Webservices - you can find some Information on the Basics on msnd http://msdn.microsoft.com/en-us/library/hh166960(v=nav.71).aspx and a more advanced example here: http://www.navida.eu/report-on-navs-account-schedules-in-excel-by-using-odata/

I hope this helps!