Formatting with DataSource

[Bryan]

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.

[Boyan Dimitrov]

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

 

 

[Bryan]

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.

 

[Boyan Dimitrov]

Hello Bryan,

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

Regards,
Boyan Dimitrov
Telerik by Progress