Category / Section
How to export ColumnHeaders with labels?
1 min read
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