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?