NAV 2017 Excel Buffer Header/Footer

BKR

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

CroRaptor

Hi, did you find a Solution? I need it too ...

AlexDen

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),
  '','');