Insert blank rows during export

[Ian]

Hi,

In our application users can upload an excel file, this data is then displayed in a Kendo spreadsheet (JQuery) control. The templates we use to insert the data have 6 blank rows at the top:

Row 7 is the header row and the data starts at row 8.

Using the built in 'Export' function on the Kendo spreadsheet we are able to export the data. What we want to be able to do is export the data in the same format it was imported. i.e. with the 6 blank rows at the top and the header row on row 7.

I have played around with sheet.insertRow(0); but this leaves 0's in the numeric columns and also blanks out the header row.

Do you have any other suggestions?

Thanks

Ian

[Dimitar]

Hi Ian,

I tested client-side and server-side Import and Export on Spreadsheet Import Export demo with an Excel file with blank rows. In all cases the blank rows are kept in the exported file. If Spreadsheet is bound to datasource, as on DataSource binding demo, then the Data Source Binding article is important. Having blank rows in this scenario is not supported. It would be helpful if you provide a Dojo snippet with the implementation on your end.

Regards,
Dimitar
Progress Telerik