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

Radgrid Excel export with Custom row on top of the sheet

5 Answers 379 Views

Grid

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

Aditya Rana asked on 17 Dec 2009, 07:44 AM

Hi ALL,

I am using ASP.Net 3.5, C# with latest Telerik component.

I am stuck with a problem related to excel export of the radgrid.

I have 2 dropdowns DDL1 and DDL2 , user select values from these 2 dropdownlist , and based on the selected values from 2 dropdownlist , I am showing data in radgrid.

Now user can export the Grid data to excel , everything is working fine upto here.

Now my problem is that how I can show the selected values of dropdownlist on top of the exported excel sheet ?

==============

for example-

Value 1 - "Selected value from DDL1" Value 2- "Selected value from DDL2"

(I want to add this row on top of the exported excel sheet.)

Exported Grid data here

==================

Please point me to right direction how can I achive this functionality ??

Thank you ,

Aditya .

5 Answers, 1 is accepted

answered on 19 Dec 2009, 05:58 PM

Hello Aditya,

The easiest way to insert custom text at the top of the exported file is to use the GridExporting event to modify the HTML output:

protected void RadGrid1_GridExporting(object source, Telerik.Web.UI.GridExportingArgs e)

{

string customHTML = "<table><tr><td>Something</td><td>Something else</td></tr><table>";

e.ExportOutput = e.ExportOutput.Replace("<body>", String.Format("<body>{0}", customHTML));

}

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 07 Jul 2010, 09:29 AM

hi,
I have a similar problem. I need to change the content of some of the cells before exporting to Word. I use the following code before exporting and also in GridExporting event. But still the original data is exported:

    
            Private Sub grdOrders_GridExporting(ByVal source As Object, ByVal e As Telerik.Web.UI.GridExportingArgs) Handles grdOrders.GridExporting 
        
                    For Each oCol As GridColumn In grdOrders.MasterTableView.Columns 
        
                        Select Case oCol.ColumnType 
        
                            Case "GridBoundColumn" 
        
                                If oCol.Visible Then 
        
                                    For Each oRow As GridItem In grdOrders.MasterTableView.Items 
        
                                        Try 
        
                                            Dim oCell = oRow.Cells(oCol.OrderIndex) 
        
                                            Dim tt = "some text..." 
        
                                            oCell.Text = tt 
        
                                        Catch ex As Exception 
        
                                            'Stop 
        
                                        End Try 
        
                                        'Stop 
        
                                    Next 
        
                                End If 
        
                        End Select 
        
                    Next 
        
                End Sub

obviously there will be some other criteria as to which cells to modify, which I have removed from code above. I think there must be a way to get the grid to reproduce the export Html string and pass it back to the event argument. Otherwise, the grid still exports the original data.

Please help,
Thanks,
safa

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Radgrid Excel export with Custom row on top of the sheet

5 Answers, 1 is accepted