• Michael Intravartolo

NAV 2013 R2 - Multiple Sheets in Excel Using Excel Buffer.


Hi All,

In this article we will see the possibility of having multiple Excel sheets using Excel Buffer Export.

Most of us know how to export data using excel buffer, but it only contain a single sheet. Now let's consider a scenario where I want to export my customers, vendors and Items from navision in excel.

So its pretty obvious that I want them in different sheets.

I have made some changes in Excel Buffer table to achieve it so let's go through them first and then we will see how to use them in report.

We have a standard function in Excel Buffer table i.e. CreateBookAndOpenExcel. What I did is create two function from the code that was written in this function. Below are the two functions.

1. Only Create Book

2. Only Open Excel


Now my sheet can be created in WriteSheet function of Excel Buffer so I added a piece of code in WriteSheet Function also as shown below


Below are some Global Variables added in Excel Buffer.


That's it. Lets create a report having three data items customer, Item and vendors.Set Report properties to ProcessingOnly to True.

And below is the code in every data item trigger.



Above is the function to print all sheets Excel header.

Below is the function to print Body for all the masters.


Let's run the report and see the output.


So we have achieved what we were trying to do - Having multiple sheets in Excel using Excel Buffer.

You can download the objects from my SkyDrive.

File Name: NAV 2013 R2 - Multiple Sheets in Excel.rar

#microsoftdynamicsnav

73 views
Contact Us

Solution Systems, Inc.

3201 Tollview Dr. 

Rolling Meadows, IL 60008

Office: 847-590-3000

Email: info@solsyst.com

Support: 224-345-2020

Support Email: support@solsyst.com

  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Chicago
  • Manufacturing Software | Illinois
  • Microsoft Business Podcast
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago