Excel Buffer Expand

CroRaptorCroRaptor Member Posts: 8
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 Member Posts: 628
    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 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 :)
  • krikikriki Member, Moderator Posts: 9,115
    [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!


Sign In or Register to comment.