Opening an Excel file in Microsoft Dynamics NAV

amisdesaga

Hello,
How to open an Excel file directly in Microsoft Dynamics NAV?
Is it possible to modify the vba code of the excel file in Microsoft Dynamics NAV before opening the file?
Is it possible to provide input parameters to the excel file before it is opened in Microsoft Dynamics NAV?

KTA8

amisdesaga wrote: »

Hello,
How to open an Excel file directly in Microsoft Dynamics NAV?
Is it possible to modify the vba code of the excel file in Microsoft Dynamics NAV before opening the file?
Is it possible to provide input parameters to the excel file before it is opened in Microsoft Dynamics NAV?

Yes, you can use excel buffer is the most common approach in the past but you can also use .net libraries.

amisdesaga

Hello,
Do you have an example or documentation on it?

KTA8

amisdesaga wrote: »

Hello,
Do you have an example or documentation on it?

https://community.dynamics.com/nav/b/dynamicsnavcloudfronts/archive/2017/07/23/exporting-record-details-to-excel-using-excel-buffer-in-microsoft-dynamics-nav-2017

https://saurav-nav.blogspot.com/2014/01/nav-2013-r2-export-to-excel-report.html

https://www.codeproject.com/Articles/28795/Very-Simple-Library-to-Work-with-Excel-in-NET

RockWithNAV

Excel Buffer is the most common way of in and out from NAV but if you have a way more records then usually it will take time but if you do it with .NET variables then it will be in just chunk of seconds but doing it with .NET it should have just a header and lines, if it have a bit complicated layout to be exported in Excel then possibly Excel Buffer will be the best approach.