Announcements
No record found.
Adding a new worksheet tab for excel export. Previous versions used Worksheets.Add With Excel 2016 in NAV2017 this fails
*This post is locked for comments
you can refer this ,
msdn.microsoft.com/.../ff839847.aspx
msdn.microsoft.com/.../ff838966.aspx
Hi
To create New Worksheet you can use like below.
XlWrkShtWriter := XlWrkBkWriter.AddWorksheet(SheetName); where you can refer Excel buffer table for XlWrkShtWriter and XlWrkBkWriter variables.
Hi Marysimmons,
Excel Buffer table (ID 370) is a good place to study how system works with Excel.
Take a look at WriteSheet function in the table, you will see how NAV adds new worksheet:
that worked in 2009 R2 with excel2013 but does not work in NAV2017 with excel2016
the question was how to add a new tab to tab to an existing worksheet
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.