GridExcelConverterControl does not include header row on export of GDBG

[Jay Mooney]

Here''s my code:

// Create Excel automation objects
IWorkbook myWorkBook = ExcelUtils.CreateWorkbook(1);
IWorksheet sheet = myWorkBook.Worksheets[0];

Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();
gecc.GridToExcel(this.Model, sheet);

// Save the workbook to disk so we can launch it via the file system
myWorkBook.SaveAs(path);
myWorkBook.Close();
ExcelUtils.ThrowNotSavedOnDestroy = false;

if (openFile)
{
// Launch the saved workbook
Process proc = new Process();
proc.StartInfo.FileName = path;
proc.Start();
}

Am I missing a setting?

[stanleyj]

Hi Jay, A defect has been logged. Here is the link to the open issues.http://www.syncfusion.com/support/issues/xlsio/Default.aspx?ToDo=view&questId=1246 Regards, Stanley

[stanleyj]

Hi Jay,

Please try setting ConverterOptions.

Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();

gecc.GridToExcel(this.gridDataBoundGrid1.Model, "sheet.xls",Syncfusion.GridExcelConverter.ConverterOptions.ColumnHeaders|Syncfusion.GridExcelConverter.ConverterOptions.RowHeaders);

Best regards,
Stanley