Bind user data to spreadsheet, activeSheet, range ect.

5 posts, 0 answers
  1. Dhruven
    Dhruven avatar
    19 posts
    Member since:
    Jun 2019

    Posted 31 Mar 2020 Link to this post

    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. 

  2. Stefan
    Admin
    Stefan avatar
    3008 posts

    Posted 01 Apr 2020 Link to this post

    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

    Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
    Our thoughts here at Progress are with those affected by the outbreak.
  3. Dhruven
    Dhruven avatar
    19 posts
    Member since:
    Jun 2019

    Posted 01 Apr 2020 in reply to Stefan Link to this post

    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. 

  4. Stefan
    Admin
    Stefan avatar
    3008 posts

    Posted 02 Apr 2020 Link to this post

    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

    Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
    Our thoughts here at Progress are with those affected by the outbreak.
  5. Dhruven
    Dhruven avatar
    19 posts
    Member since:
    Jun 2019

    Posted 02 Apr 2020 in reply to Stefan Link to this post

    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.

Back to Top