Haw to add PageBreaks to excell worksheet.

Andrzej
Andrzej Member Posts: 2
in NAV Tips & Tricks
Hi,
I've prepared excell worksheet using ExcellBuf.
To meet the requirements should have Page Breaks.
Is any method to ad it using CA/L ?

Answers

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Hi,

    Start from recording a macro in Excel inserting a page break at a certain position.

    It will give you a sniplet of VBA code, which you will need to replicate in C/AL, using relevant automation objects or DotNet vars.

    Regards,
    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • Andrzej
    Andrzej Member Posts: 2
    Thanks for sugestion.

    I've got samthing like this in VB:

    Set ActiveSheet.VPageBreaks(1).Location = Range("Q1")
    Set ActiveSheet.HPageBreaks(1).Location = Range("A90")

    whitch .net libreary and function can I use to do it in CA/L ?
    Sorry for question but I'm begginer in .net

Categories