Formatting with DataSource

4 posts, 1 answers
  1. Bryan
    Bryan avatar
    28 posts
    Member since:
    Oct 2014

    Posted 31 Aug Link to this post

    I was wondering how to insert a row above the first row of the spreadsheet when binding to a datasource. I can achieve the desired result by specifying the cells I want by looping through the datasource and specifying the cell values dynamically, but this slows everything down considerably.

  2. Answer
    Boyan Dimitrov
    Admin
    Boyan Dimitrov avatar
    1746 posts

    Posted 02 Sep Link to this post

    Hello Bryan,

    I would suggest to access the dataSource for the specific sheet using the dataSource property of the Kendo UI SpreadSheet and use the Kendo UI DataSource API (insert method in this case). 

    Regards,
    Boyan Dimitrov
    Telerik by Progress
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
  3. Kendo UI is VS 2017 Ready
  4. Bryan
    Bryan avatar
    28 posts
    Member since:
    Oct 2014

    Posted 06 Sep in reply to Boyan Dimitrov Link to this post

    Not sure if that would help me, considering the datasource binds the schema field names in the top row, and I'm trying to insert a row above that.

     

  5. Boyan Dimitrov
    Admin
    Boyan Dimitrov avatar
    1746 posts

    Posted 08 Sep Link to this post

    Hello Bryan,

    In this case you can take advantage of the insertRow method of the Sheet object. 

    Regards,
    Boyan Dimitrov
    Telerik by Progress
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
Back to Top
Kendo UI is VS 2017 Ready