GDBG and GridToExcel

[Michael Cruanes]

Hi,
I am using Syncfusion 4.1.0.62 and .Net 2.0.
I want to export the GDBG to Excel using GridExcelConverter.GridToExcel.
Unfortunately, the ComboBox column exports the value instead the displayed text.
Is there any way to change that ?

Thank you for your support,
Michael

[Administrator]

Hi Michael,

There is no built-in support for display text exporting in a grid.But this can be achieved by changing the value member of the combobox celltype in a grid.Here is a code snippet.

ChangeValueMamber();
Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();
gecc.GridToExcel(this.gridControl1,@"C:\MyExcel.xls",Syncfusion.GridExcelConverter.ConverterOptions.Default);
ResetChangeValueMember();

Here is a sample for implementing it.
http://www.syncfusion.com/Support/user/uploads/DemoProj_9200e65d.zip

Let me know if you need any further assistance.

Thanks for choosing Syncfusion Products.
Regards,
Haneef

[Michael Cruanes]

Hi Haneef,

Unfortunately, I have some GUID CellValueType and it seems to be a problem for the cell validation.
Anyhow, I am using now a temporary grid control that I fill with the displayed content of the GDBG. I call GridToExcel with the temporary grid as parameter and it is seems to work.
I think you can close this issue.

Kind Regards,
Michael