This is a migrated thread and some comments may be shown as answers.

Exporting ExcelML with rows injected

2 Answers 28 Views
Grid
This is a migrated thread and some comments may be shown as answers.
R Stewart
Top achievements
Rank 1
R Stewart asked on 08 Jul 2010, 09:00 PM
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

2 Answers, 1 is accepted

Sort by
0
Accepted
Daniel
Telerik team
answered on 14 Jul 2010, 02:29 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
R Stewart
Top achievements
Rank 1
answered on 29 Jul 2010, 04:53 PM
Thanks, seems to work. I'm not sure why I didn't try that in the first place.
Tags
Grid
Asked by
R Stewart
Top achievements
Rank 1
Answers by
Daniel
Telerik team
R Stewart
Top achievements
Rank 1
Share this question
or