Export To Excel Button In menubar not working

madankhemka
madankhemka Member Posts: 6
edited 2011-08-30 in NAV/Navision Classic Client
Hi All

I am not able to export particular sales orders in excel using default export to excel button in menubar. When I click on the button, excel opens but there is an error"Workbook setting".

Please guide me to solve this problem

Comments

  • vaprog
    vaprog Member Posts: 1,163
    In it's error message. Excel probably gives you the name of a file where you can find more details about the error.

    The file Excel openes is an XML file produced by applying the stylesheet (an xsl transform .xslt) to an XML representation of the form.

    So, what you need to do is to change the stylesheet so it creates a valid excel document.

    To do this, i found it usually helps to see a copy of the source xml file to which the transform is applied. To get one, modify function LaunchApp in Codeunit 403 Application Launch Management. Add DataXML.save just before DataXML.transformNodeToObject.
  • madankhemka
    madankhemka Member Posts: 6
    Thanks for reply


    But I am using NAV 5.0.
  • vaprog
    vaprog Member Posts: 1,163
    madankhemka wrote:
    But I am using NAV 5.0.

    What do you mean to say?

    That functionality is there since 5.0. The XML representation of the form and the MSXML automation version used changed at some point since, (and therefore the stylesheet may not be compatible between 5.0 and 2009 R2) but the principle working is still the same.
  • madankhemka
    madankhemka Member Posts: 6
    But there is no such code in Launch App function

    Actually in some order error is there. not in all

Categories