Export to Excel with pivot table, how to?

arcull · 2014-02-24

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. · 2014-02-24

Take a look at codeunit 424 Export Analysis View.

arcull · 2014-02-25

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 · 2014-02-26

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!

Export to Excel with pivot table, how to?

Comments

Categories