VIBlend - .NET Controls and Components for Silverlight, WPF and Windows Forms

// Client Login

Home

Products

Downloads

Purchase

Support

About

WinForms Controls

WinForms DataGrid

Navigation Bars

Ribbon Interface

Calendar Control

TreeView Control

ComboBox Control

ListBox Control

Common Controls

Tab Control

OLAP Pivot Table

Free Controls

Silverlight Controls

Silverlight DataGrid

Scheduler Control

Ribbon Bar Control

Common Controls

Data Entry Controls

List Controls

ComboBox Control

Menu Control

TreeView Control

Navigation Bars

Tab Control

OLAP Pivot Table

WPF Controls

WPF DataGrid

Data Entry Controls

Navigation Bars

WPF Tab Control

How to export DataGrid's data to Excel?

Article Information

Article relates to VIBlend DataGrid for Silverlight

How To

Export DataGrid's data to Excel.

Solution

In order the export the DataGrid's data to excel you should call the ExportToExcelXML method of the GridExport class.

C#

saveFileDialog1.Filter = "Microsoft Excel XML Spreadsheet (*.xml)|*.xml";
bool? show = saveFileDialog1.ShowDialog();

VIBlend.Silverlight.Controls.GridExport gridExport = new VIBlend.Silverlight.Controls.GridExport();
            
using (Stream stream = saveFileDialog1.OpenFile())
{
    if (gridExport.ExportToExcelXML(this.dataGrid, stream))
        MessageBox.Show("Export Complete", "GridView Export APIs", MessageBoxButton.OK);
    else
        MessageBox.Show("Export Failed", "GridView Export APIs", MessageBoxButton.OK);
}
   
VB .NET

saveFileDialog1.Filter = "Microsoft Excel XML Spreadsheet (*.xml)|*.xml"
Dim show As Nullable(Of Boolean) = saveFileDialog1.ShowDialog()

Dim gridExport As New VIBlend.Silverlight.Controls.GridExport()

Using stream As Stream = saveFileDialog1.OpenFile()
	If gridExport.ExportToExcelXML(Me.dataGrid, stream) Then
		MessageBox.Show("Export Complete", "GridView Export APIs", MessageBoxButton.OK)
	Else
		MessageBox.Show("Export Failed", "GridView Export APIs", MessageBoxButton.OK)
	End If
End Using

Silverlight Controls	WinForms Controls	Knowledge Base	About Us

Silvelright DataGrid	Ribbon Interface	Technical Support	Blog
Silverlight Editors	WinForms DataGrid
Silverlight Ribbon Bar	Calendar	Downloads	Forum
Navigation Bars	Navigation Bars
Menu & ContextMenu	TreeView	Purchase Online	Client Login
ComboBox & ListBox	Tab Control
Silverlight Pivot Table	WinForms Pivot Grid	Request a feature	Report a bug