about GetLastNonEmptyColumn Method

Posted by: wwu-sec on 8 September 2017, 12:33 pm EST

  • Posted 8 September 2017, 12:33 pm EST

    dear farpoint developer:



    FarPoint.Win.Spread Assembly Reference



    GetLastNonEmptyColumn Method

    farpoint API provide such method, but the range is treat a whole sheet as a single spectrum,

    i wish there is a method base on certain column or certain row level,

    say, i want to know rowIndex(3) [4th row] 's lst non empty cell's location, is there any convenient way to handle this?



    i'm in a hurry project, keep good work



    thanks a lot
  • Replied 8 September 2017, 12:33 pm EST

    There is not another way to do this other than on the sheet level.  I'm not sure exactly what you are looking for.  There is an IsRowUsed method for the data model that returns whether a row is empty or not, but I'm not sure that's what you are looking for.
  • Replied 8 September 2017, 12:33 pm EST

    Hello,


    You would need to use the GetLastNonEmptyColumn and then programatically search the text in the cell that would be this column of the row you want backwards finding the first cell with data and that would be your answer.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels