How can I find out the last row/last column that have value/fomular

Posted by: levanduyet-fp on 8 September 2017, 3:01 pm EST

  • Posted 8 September 2017, 3:01 pm EST

    Hi,

    Which function that I can use to define the last row/last column that have value/fomular in the Spread.

    Tks,

    Duyet

  • Replied 8 September 2017, 3:01 pm EST

    Hello,

    You can use the GetLastNonEmptyRow method to get the index of the last row with data, please refer to the follwoing link that describes the same:

            http://www.gcpowertools.com/help/spreadnet6/WF2/FarPoint.Win.Spread~FarPoint.Win.Spread.SheetView~GetLastNonEmptyRow.html

    Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur

Need extra support?

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

Learn More

Forum Channels