Insert blank rows during export

1 Answer 6 Views
Spreadsheet
Ian
Top achievements
Rank 1
Ian asked on 05 Jan 2022, 05:06 PM

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

1 Answer, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 10 Jan 2022, 11:47 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tags
Spreadsheet
Asked by
Ian
Top achievements
Rank 1
Answers by
Dimitar
Telerik team
Share this question
or