How to find used cell range in spreadsheet ?

2 posts, 0 answers
  1. Mahesh
    Mahesh avatar
    2 posts
    Member since:
    Jun 2017

    Posted 31 Jul 2017 Link to this post


    I would like to know how to find what cells are used in the spreadsheet. I want to validate & process all entered values.

     Instead of iterating all the rows, if we iterate only used cell range, it will take less time to execute. 

    I have referred the below link but couldn't find the mentioned option in the below link.

    Please help me.


  2. Veselin Tsvetanov
    Veselin Tsvetanov avatar
    1241 posts

    Posted 02 Aug 2017 Link to this post

    Hello Mahesh,

    I am afraid, that the Kendo UI Spreadsheet does not expose method or property, that would allow you to retrieve only those cells, which contain values. If you think, that such functionality would add considerable value to the widget, I would suggest you to log your idea in our Feedback portal. Based on the support it receives from the community, we will decide on whether to proceed with its implementation or not.

    Also, I would suggest you to review the usage of the Sheet.batch() method, which can help you improve the performance of the cells manipulations executed.

    Veselin Tsvetanov
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top