How to Export the excel layout using ExcelBuffer

Jacob1227
Jacob1227 Member Posts: 128
in NAV Three Tier
Hi All,

I have a button called 'ExportSaleLine' on the Sales order page. While clicking the button in the sales order, it has to show the output like the below screenshot.

ooooa988l1ot.png

Please advise me on how to make the 'Company Logo'(with proper merge) part and Company Info part (B column with address details and D and E column with order and Order No) using Excel buffer table in the report.(reference link https://community.dynamics.com/nav/b/dynamicsnavcloudfronts/posts/exporting-record-details-to-excel-using-excel-buffer-in-microsoft-dynamics-nav-2017)

Please help me with the Company logo part and Company info part to show in excel sheet like the above image.

Thanks in Advance,
Jacob.A

Answers

  • ftornero
    ftornero Member Posts: 524
    Hello @Jacob1227 ,

    With the ExcelBuffer you can not send an image to Excel, but maybe is easier to create a Report with the information that you need and then run with SAVEASEXCEL.

    Regards.
  • Jacob1227
    Jacob1227 Member Posts: 128
    ok @ftornero thanks, in the line part how can i make the header of the line start from the 10th row of the excel sheet?
  • ftornero
    ftornero Member Posts: 524
    Hello @Jacob1227 ,

    That will be a trail and error process I gess, modfiying the logo size

    7zobvyy5apm6.png

    And this is the result:

    kgijriiylvkf.png

Categories