Telerik blogs

How To: Quick export to Excel (XLSX) for WPF and Silverlight

by Vladimir Enchev
April 22, 2013 Desktop, WPF 0 Comments


Did you know that using the core of our brand new spreadsheet component you can easily export data to Excel?

What you need actually is reference to:
Telerik.Windows.Documents.Core.dll
Telerik.Windows.Documents.Spreadsheet.dll
Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.dll
Telerik.Windows.Zip.dll

and simple code for exporting (for example RadGridView):

private static Workbook CreateWorkBook(RadGridView grid)
{
    var workbook = new Workbook();
    var worksheet = workbook.Worksheets.Add();
 
    for (var i = 0; i < grid.Items.Count; i++)
    {
        for (var j = 0; j < grid.Columns.Count; j++)
        {
            var boundColumn = grid.Columns[j] as GridViewBoundColumnBase;
            if (boundColumn != null)
            {
                worksheet.Cells[i, j].SetValue(string.Format("{0}", boundColumn.GetValueForItem(grid.Items[i])));
            }
        }
    }
 
    return workbook;
}

For more info about RadSpreadsheet please check our documentation for Silverlight and WPF!

You can also download two identical example applications for Silverlight and WPF.

Enjoy!
Excel, Export, Silverlight, WPF
About the Author

Vladimir Enchev

is Director of Engineering, Native Mobile UI & Frameworks

Related Posts

Web Mobile Desktop WPF .NET MAUI Blazor Desktop/.NET MAUI Blazor

What to Know When Porting a WPF App to .NET MAUI Blazor Hybrid

Mobile Desktop Web WPF .NET MAUI

Transform a WPF App to Cross-Platform with .NET MAUI

Release Web Mobile Desktop Productivity

The Telerik and Kendo UI R2 2023 Release Is Here—See What’s New!

Comments

Comments are disabled in preview mode.