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.

 

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