Excel Buffer Expand

CroRaptor
CroRaptor Member Posts: 8
in NAV Three Tier
Hello Guys

I will slowly despair... I have a problem. I need to expand the "Excel Buffer" with a function with 2 parameters. First parameter "From Cell" second Parameter "To Cell". Then i need somehow to Delete all Rows between this 2 Parameters. Somehow i have tried with multiple DotNet's but nothing works!! It should be connected with the Worksheet .net used in the Excel Buffer.
It can't be that hard :neutral:

can you guys help me?

best regards
CroRaptor

Answers

  • lubost
    lubost Member Posts: 633
    You have to loop ExcelBuff records, because each cell is represented by row in table. If your range has same row value you can use SETRANGE statement.
  • CroRaptor
    CroRaptor Member Posts: 8
    this wouldn't work because i have to delete the variable formatting and colors of the Template excel. But i found a way :)
  • kriki
    kriki Member, Moderator Posts: 9,121
    [A part of the discussion is also in the following (closed) topic]
    See https://forum.mibuso.com/discussion/73167


    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories