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