NAV 2017 Excel Buffer Header/Footer

BKR
BKR Member Posts: 1
in NAV Three Tier
Hello everybody,
are there any possibilites to add Header or Footer Information via Excel Buffer to an exported Excel?

Theres a function in Table 370, CreateBookAndOpenExcel, Parameter ReportHeader. But thats only a centered Report Header. I need a left and a right header.
Are there possibilities? Tips and tricks?

Further I have to set a page margin, no clue how to do this...

Thanks for your help.
BKR

Comments

  • CroRaptor
    CroRaptor Member Posts: 8
    Hi, did you find a Solution? I need it too ...
  • AlexDen
    AlexDen Member Posts: 86
    Hi,

    You can make left and right headers with an existing function, just need to use special symbols:
    LeftHeader := 'Left header';
CenterHeader := 'Center header';
RightHeader := 'Right header';

ExcelBuffer.CreateBookAndOpenExcel(
  '','Test',
  STRSUBSTNO('&L%1&C%2&R%3',LeftHeader, CenterHeader, RightHeader),
  '','');

Categories