Bind user data to spreadsheet, activeSheet, range ect.

[Dhruven]

Hi, 

I am working with spreadsheet wrapper component with React.

In my scenario, I want to bind some user data, something like { a : 1234 } to a specific cell or a row or a column, is it possible? Even if I can just bind a string instead of an object that will be okay. Also, I want to bind that data but don't want to show it to users, it should just be accessible through the code.

I tried looking into the API references but not able to find anything like that.

If it is possible, can I get a small example for it?

 

Thank you. 

[Stefan]

Hello, Dhruven,

Is it possible to share more details about the use case as I may be missing an important detail?

If the data will not be shown in the Spreadsheet and only used programmatically, why it has to be bound to the Spreadsheet instead of being saved in a variable and used when needed.

Regards,
Stefan
Progress Telerik

[Dhruven]

Thank you for your reply.

I can try to explain a little bit about my use case in very simple terms and give you an overview of what I need.

I have a scenario where I am adding multiple rows by few events. Now when I add a row I am generating a unique id for that row and saving it in database. Now I have another button that fire an event and gives me the id for the row to remove. So, I want to bind that id as a string data to the rows or cells of that row, or I want to attach the object of id and row number to spreadsheet. So, I can identify the right row to remove. Obviously, there are few more conditions where I need to attach some user define data to a specific range. But this is the best scenario that I can share and describe right now. 

Thank you again. 

[Stefan]

Hello, Dhruven,

Thank you for the details.

As the Spreadsheet is a wrapper over the Kendo UI Spreadsheet, it also has the capabilities to be connected to a dataSource for data management.

Please check the following article and advise if this is something that proves helpful in this case:

https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/import-and-export-data/bind-to-data-source

Regards,
Stefan
Progress Telerik

[Dhruven]

Thank you for your reply again. 

I will look into it and will also do some experiments with DataSource.

If it doesn't work, I will contact on this thread again. 

 

Thank you.