Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Excel Import in Ax 2012 Enterprise Portal

Posted on by 527

I am trying to import excel in Enterprise portal in Ax 2012

For that i have done the following

-> created a new webpage and used asp fileupload control in the page to load the excel file.

-> After loading the file i have called the Ax method where i have written code to read the excel

This excel import is working in some machines but in some machines i am getting the following errors

when trying to import the excel

  • COM object of class Excel.Application could not be created.Ensure that object has been properly registered   on computer
  • object 'COM'could not be created
  • Ensure that Microsoft Excel is installed

Does any one have any idea what might be the problem ?

Note : microsoft excel is properly installed in the machine and the version is same in both the

environments where the import is working properly and not working properly

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Excel Import in Ax 2012 Enterprise Portal

    Thanks! but I can not find the dll  'Excel.Application' ,can you help me?

  • Suggested answer
    Adrian Pascari A Profile Picture
    Adrian Pascari A 1,681 on at
    RE: Excel Import in Ax 2012 Enterprise Portal

    Here is described how to add your assembly to GAC: shivasoft.in/.../how-to-add-dll-dynamic-linking-library-in-gac-global-assembly-cache

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Excel Import in Ax 2012 Enterprise Portal

    How to "2. Add your dll 'Excel.Application' under GAC on AOS server." ? I don't know what to do

  • Suggested answer
    Adrian Pascari A Profile Picture
    Adrian Pascari A 1,681 on at
    Re: Excel Import in Ax 2012 Enterprise Portal

    1. Change the Ax class to be with property 'Called from server'.

    2. Add your dll 'Excel.Application' under GAC on AOS server.

    3. Restart AOS.

    4. Add reference under AOT->references.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans