Export data with view definition from radgridview to excel in UI for WinForms

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

Export data with view definition from radgridview to excel

3 Answers 12 Views

GridView

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

3 Answers, 1 is accepted

answered on 03 Nov 2020, 03:42 PM

Hello, Harsha,

It seems that use GridViewSpreadExport. The spread export functionality is located in the TelerikExport.dll assembly which must be added to your project. You need to include the Telerik.WinControls.Export namespace in order to access the SpreadExportRenderer.

Then, you can use the following code snippet to export the grid:

  private void radButton1_Click(object sender, EventArgs e)
  {
      GridViewSpreadExport spreadExporter = new GridViewSpreadExport(this.radGridView1);
      SpreadExportRenderer exportRenderer = new SpreadExportRenderer();
      spreadExporter.FileExportMode = FileExportMode.CreateOrOverrideFile;
      spreadExporter.RunExport("D:\\exportedFile.xlsx", exportRenderer);
      Process.Start("D:\\exportedFile.xlsx");
  }

I hope this helps. Let me know if you have other questions.

Regards,
Nadya
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

answered on 04 Nov 2020, 12:21 PM

Hello, Harsha,

Yes, the TelerikExport.dll is available in the 2016.1.216.20 version. You should carefully check in your installation folder:

I would encourage you to upgrade to the latest version if possible. Thus, you can benefit from all the introduced improvements since 2016. The latest version is 2020.3.1020.

I hope this information helps. Let me know if you have other questions.

Regards,
Nadya
Progress Telerik