web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

BC18 : Microsoft.Dynamics.Nav.Integration.Office.Excel.ExcelHelper Missing

(0) ShareShare
ReportReport
Posted on by 22

While upgradation from BC17 to BC18 Microsoft has removed Excel class from "Microsoft.Dynamics.Nav.Integration.Office.dll".
Is there any alternative for it ?

I have the same question (0)
  • Suggested answer
    Brian Wick Profile Picture
    on at

    Hi Ravi,

    Could you share what you were using it for and maybe we could find an alternative?  As far as I am aware the dll you mention was not released with either 17.5 or 18.0.  Thanks.

  • Ravi Profile Picture
    22 on at

    Hello Brian,

    This DLL is present till 17.0 (was present in 16 also and after 17.0 i haven't checked yet).

    Regarding usage :

    public static class ExcelHelper

    {

    public static void ActivateSheet(Workbook workbook, string sheetName)

    public static void AutoFitColumnsInAllWorksheets(Workbook workbook)

    public static void AutoFitRangeColumns(Workbook workbook, string sheetName, string rangeName)

    public static void BorderAroundRange(Workbook workbook, string sheetName, string rangeName, int lineStyle)

    public static Workbook CallOpen(Application application, string fileName)

    public static void CallQuit(Application application)

    }

    This was the ExcelHelper class and these are the function that i am using from it.

    Is there any alternative for it ?

    or they have been moved to some other DLL ?

  • Suggested answer
    THE Italian Profile Picture
    on at

    These were very old and mostly used with automation or client side Excel handling. This technology no longer works hence it has been removed. 

    You might inspect OpenXML management codeunit and what it does.

    And this milestone blog post How to use the Excel Buffer in Business Central cloud – Kauffmann @ Dynamics 365 Business Central

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans