Export to multiple sheet in excel - Nav 2018

Djou2424Djou2424 Member Posts: 75
I'm looking for an exemple of how to export data to excel in Navision 2018 using multiple sheets.
We have a custom report for one of our client in nav 2013 R2 that export orders informations to different excel spreadsheet.
Now that we are upgrading them to 2018, the code is not working anymore

Here is part of the code in 2013 R2 that is working fine:

Here is the error message we get in 2018 when running the same report

Here is where in the code of the excel buffer table it's failing


  • vaprogvaprog Member Posts: 958
    OnlyCreateBook is no standard function. Nor are the Add... functions.

    ExcelBuffer used to use Automation in order to remote control Excel. It now uses Dotnet OpenXML library to create a document directly.

    You will have to re-implement extensions to your Excel Buffer using that library.
  • Djou2424Djou2424 Member Posts: 75
    Ok, do you know where I could find an example of how to do that?
  • Djou2424Djou2424 Member Posts: 75
    Still looking for help on how to do this
Sign In or Register to comment.