This is a migrated thread and some comments may be shown as answers.

How to find used cell range in spreadsheet ?

1 Answer 392 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Mahesh
Top achievements
Rank 1
Mahesh asked on 31 Jul 2017, 08:26 AM

Hi

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. 

  http://www.telerik.com/forums/spreadsheet-row-and-column

Please help me.

 

1 Answer, 1 is accepted

Sort by
0
Veselin Tsvetanov
Telerik team
answered on 02 Aug 2017, 08:34 AM
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.

Regards,
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.
Tags
Spreadsheet
Asked by
Mahesh
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Share this question
or