Excel Buffer Expand

CroRaptorCroRaptor Posts: 7Member
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

  • lubostlubost Posts: 529Member
    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.
  • CroRaptorCroRaptor Posts: 7Member
    this wouldn't work because i have to delete the variable formatting and colors of the Template excel. But i found a way :)
  • krikikriki Posts: 8,689Member, Moderator
    [A part of the discussion is also in the following (closed) topic]
    See https://forum.mibuso.com/discussion/73167


    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2019: 21 & 22 November 2019, Antwerp (Belgium)
Sign In or Register to comment.