.NET > WPF >> Intro To WPF Views : 4860
Telerik Grid
Rate This Article :

Binding and Export To Excel with TelerikRadGrid

Step1:

Add Telerik RadGriew reference to your project. Same will be found in this link .

Step 2:

Include the telerik controls namespace in your xaml file as shown below;

<Window x:Class="TelerikGridSampleApplication.MainWindow"

        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

        Title="MainWindow" Height="350" Width="525"

        xmlns:Controls="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.GridView">

 Step 3:

Add telerik 'RadGridView' control to your xaml file, and set the property ‘AutoGenerateColumns’ to ‘True’, so that the coulmns will be automatically generated based on the objects binded. I have also added a button called ‘Export to Excel’ and we are going to export data to excel in the click event of this button.

<Grid>

     <Grid.RowDefinitions>

            <RowDefinition Height="Auto"/>

            <RowDefinition Height="*"/>

            <RowDefinition Height="Auto"/>

     </Grid.RowDefinitions>

     <TextBlock Grid.Row="0" Text="Telerik Grid Example" Foreground="CadetBlue" FontSize="20" 

FontWeight="Bold"HorizontalAlignment="Left" VerticalAlignment="Top"/>

     <Controls:RadGridView x:Name="radGrid" Grid.Row="1" AutoGenerateColumns="True"

HorizontalAlignment="Stretch" VerticalAlignment="Stretch"></Controls:RadGridView>

     <Button x:Name="ExportButton" Grid.Row="2" Content="Export To Excel"

 HorizontalAlignment="Right"VerticalAlignment="Bottom" Click="ExportButton_Click" />

</Grid>

Step 4:

In the code behind, create a class to bind data to the rad grid. For simplicity, I have created a class ‘Student’ as shown below;

public class Student

    {

        public string StudentName { get; set; }

        public int RegisterNumber { get; set; }

        public int TotalMarks { get; set; }

    }

Step 5:

Let’s create a list of students with dummy data and assign the list to radgrid as source.

private void PopulateRadGridWithData()

        {

            var Student1 = new Student { StudentName = "Student 1", RegisterNumber = 302001, TotalMarks = 420 };

            var Student2 = new Student { StudentName = "Student 2", RegisterNumber = 302002, TotalMarks = 340 };

            var Student3 = new Student { StudentName = "Student 3", RegisterNumber = 302003, TotalMarks = 280 };

            var Student4 = new Student { StudentName = "Student 4", RegisterNumber = 302004, TotalMarks = 444 };

            var Student5 = new Student { StudentName = "Student 5", RegisterNumber = 302005, TotalMarks = 300 };

            var dataList = new List<Student> { Student1, Student2, Student3, Student4, Student5 };

            radGrid.ItemsSource = dataList;

        }

Step 6:

Now we need to invoke the method 'PopulateRadGridWithData()' in the constructor of code behind, so that the rad grid will be populated with data when the page is loaded.

        public MainWindow()

        {

            InitializeComponent();

            PopulateRadGridWithData();

        }

 Step 7:

We have rad grid ready, now let's export it to excel on button click event of ‘Export to Excel’ button.

In radgrid, we can achieve this by calling the method Export(). The input parameters of this method are ‘Stream’ object and ‘GridViewExportOptions’ object. You need to create an excel file and convert it to filestream object and give this object as an input to Export() method, so that the contents are written directly into this stream. GridViewExportOption determines the format in which you want to export your data, whether you need to include headers of the readgrid or not and few more options.

private void ExportButton_Click(object sender, RoutedEventArgs e)

{

    var directory = @"D:\POCs\ExportToExcel";

    var fileName = "StudentReport.xls";

    if(!Directory.Exists(directory))

    {

        Directory.CreateDirectory(directory);

    }

    if(File.Exists(directory+@"\"+fileName))

    {

        File.Delete(directory+@"\" + fileName);

    }

    using (FileStream fileStream = File.Create(directory + @"\" + fileName))

    {

        radGrid.Export(fileStream, new GridViewExportOptions(){Format = ExportFormat.ExcelML, ShowColumnHeaders = true, Encoding = Encoding.Unicode});

    }

     MessageBox.Show("Successfully Exported.", "Result");

}

 Step 8:

That’s it;  you have created a simple WPF application with rad grid and export to excel functionality. If you run this application, you’ll get output as shown below;

Generated Telerik Grid:

RadGridView.png

Generated Excel:

ExcelRadGrid.png

 

About Author
manojkumar.simhs
Total Posts 1
Having exp in 3 years in .Net Technology
Comment this article
Name*
Email Address* (Will not be shown on this website.)
Comments*
Enter Image Text*
   
View All Comments
Rajkumar
Hi Ashwin, There are many ways to achieve this functionlity. Below mentioned option will work. 1. Try creating the new instance Telerik Grid in the Code Behind Method and assign data to the newly created Telerik Grid and use the same export option. Note - Don't set the page count. Check and let me know your comments.
Ashwin kumar
This is working but it exports only page. I have 50 pages in my project and i want to export all those 50 pages . What should i do and where should i write code to export all the 50 pages. Thanks in advance
  Privacy   Terms Of Use   Advertise With Us   Contact Us
© 2016 Developerin.Net. All rights reserved.
Trademarks and Article Images mentioned in this site may belongs to Microsoft and other respective trademark owners.
Articles, Tutorials and all other content offered here is for educational purpose only and its author copyrights.