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.