Nav.Integration.Office.Excel.ExcelHelper Replacement in BC

NAVFuchsNAVFuchs Member Posts: 69
Hi,

I have to make an update of a codeunit from NAV2017 to BC19. As there does not exist anymore
the Excelhelper, I have replace some of these functions.

Microsoft.Dynamics.Nav.Integration.Office.Excel.ExcelHelper.'Microsoft.Dynamics.Nav.Integration.Office, Version=10.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'


XlHelper.AutoFitRangeColumns(XlWrkBk, ActiveSheetName, RangeName);

XlHelper.BorderAroundRange(XlWrkBk, ActiveSheetName, RangeName, 1);

XlHelper.CallQuit(XlApp);

XlHelper.CallOpen(XlApp, FileNameClient);

XlHelper.AutoFitColumnsInAllWorksheets(XlWrkBk);

XlHelper.ActivateSheet(XlWrkBk, ActiveSheetName);


How can I replace/rewrite these functions?

best regards
Sign In or Register to comment.