How to export ColumnHeaders with labels?
In order to export the grid with column headers, the ConverterOptions enum value can be set as ColumnHeaders.
Code Snippet:
C#
Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Files(*.xls)|*.xls";
saveFileDialog.DefaultExt = ".xls";
if (saveFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
gecc.GridToExcel(this.gridDataBoundGrid1.Model, saveFileDialog.FileName, Syncfusion.GridExcelConverter.ConverterOptions.ColumnHeaders);
if (MessageBox.Show("Do you wish to open the xls file now?", "Export to Excel", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
Process proc = new Process();
proc.StartInfo.FileName = saveFileDialog.FileName;
proc.Start();
}
}
VB
Dim gecc As New Syncfusion.GridExcelConverter.GridExcelConverterControl()
Dim saveFileDialog As New SaveFileDialog()
saveFileDialog.Filter = "Files(*.xls)|*.xls"
saveFileDialog.DefaultExt = ".xls"
If saveFileDialog.ShowDialog() = System.Windows.Forms.DialogResult.OK Then
gecc.GridToExcel(Me.gridDataBoundGrid1.Model, saveFileDialog.FileName, Syncfusion.GridExcelConverter.ConverterOptions.ColumnHeaders)
If MessageBox.Show("Do you wish to open the xls file now?", "Export to Excel", MessageBoxButtons.YesNo, MessageBoxIcon.Question) = System.Windows.Forms.DialogResult.Yes Then
Dim proc As New Process()
proc.StartInfo.FileName = saveFileDialog.FileName
proc.Start()
End If
End If
Screenshot
Sample links
