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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Auto fit in excel buffer
Microsoft Dynamics NAV (Archived)

Auto fit in excel buffer

(0) ShareShare
ReportReport
Posted on by NavTech 2,390

I am exporting data in excel using excel bufer in nav 2017 . I tried alot on google to find a solution to auto fit data . But no solution worked for me . I am not able to use variable XlWrkBk. I don't know how to instantiate it. Please help.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,247 Super User 2025 Season 2 on at 
    LOCAL PROCEDURE PostOpenExcel@8();
    BEGIN
      XlWrkBk := XlApp.ActiveWorkbook;

      IF ISNULL(XlWrkBk) THEN
        ERROR(Text036);

      // autofit all columns on all worksheets
      XlHelper.AutoFitColumnsInAllWorksheets(XlWrkBk);

      // activate the previous saved sheet name in the workbook
      XlHelper.ActivateSheet(XlWrkBk,ActiveSheetName);
    END;


    I think they might have removed the funciton in 2017, check in NAV 2015 there is a function in the Excel Buf called AutoFit and function in teh XlHelper to AutoFitAllColumns. It is called during OpenExcel in the PostOpenExcel Function.

  • Community Member Profile Picture
    Community Member on at

    [quote][/quote]

    I am exporting data in excel using excel bufer in nav 2017 . I tried alot on google to find a solution to auto fit data . But no solution worked for me . I am not able to use variable XlWrkBk. I don't know how to instantiate it. Please help.

    I'm also facing the issue, please help me to resolve this issue.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans