Exporting ExcelML with rows injected

[R Stewart]

Is it possible to insert rows into the Export? I'd like to add a row between the header and the first data row.

I had attempted to do the following in the ExcelMLExportRowCreated method but it ends up not showing any of the data.

If e.RowType = GridExcelBuilder.GridExportExcelMLRowType.HeaderRow Then
    Dim r As New GridExcelBuilder.RowElement
    For Each cell As GridExcelBuilder.CellElement In e.Row.Cells
        Dim c As New GridExcelBuilder.CellElement
        c.Data.DataItem = "test"
        r.Cells.Add(c)
    Next
    'e.Worksheet.Table.Rows.Add(r)
    'e.Worksheet.Table.Rows.Insert(1, r)
End If

[Daniel]

Hello R Stewart,

Please download the attached demo and let me know whether it works as expected on your end.

Best regards,
Daniel
the Telerik team

[R Stewart]

Thanks, seems to work. I'm not sure why I didn't try that in the first place.