Programmatically sort columns(s) before exporting

[JM]

Good day.

Is there a way to sort column(s) before exporting the grid to Excel? I would like to perform sorting in the ConfigureExport() method of the demo RadGrid Export source.

Thanks in advance.

JM

[Vlad]

Hi JM,

You can use ExcelML export and add the following code to ConfigureExport() method:

        public void ConfigureExport()
        {
            GridSortExpression exp = new GridSortExpression();
            exp.FieldName = "ContactName";
            exp.SortOrder = GridSortOrder.Descending;

            RadGrid1.MasterTableView.SortExpressions.AddSortExpression(exp);

            RadGrid1.ExportSettings.ExportOnlyData = CheckBox1.Checked;
            RadGrid1.ExportSettings.IgnorePaging = CheckBox2.Checked;
            RadGrid1.ExportSettings.OpenInNewWindow = CheckBox3.Checked;
        }

Greetings,
Vlad
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.