How to Export the excel layout using ExcelBuffer

Jacob1227

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.



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

ftornero

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

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

Hello @Jacob1227 ,

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



And this is the result: