Export to excel problem.

[Marcin]

Hello,
i implemented export to excel using RadGridViewExcelExporter and i have some question:
1. In grid i have radgridcomboboxcolumn and i use dictionary to show data f.e
 DataSource = bindingSource(Dictionary)
 Display member = Value
 Fieldname = Id
 ValueMember = Key
 when i export data to excel in this column i have Id but i want to export Value f.e "Dog". Can I change it ?
2. RadGridViewExcelExporter is very slow f.e 1000 rows ;/, can i optymize this mechanism ?
3. I try to use ExportCSV, but i have comma separated "," and in excel i must have ";" for good formatting, can i change it ?
Thanks for any help.

[Emanuel Varga]

Hello Marcin,

I would suggest using Export to Excel via ExcelML Format.

This way it will export by default combo box columns + you can handle all the extra formatting you require by handling the

ExcelCellFormatting

event.

Another advantage of this method is that is is much faster than the one you are using.

For more info please take a look at the link i have provided.

Hope this helps, if you have any other questions or comments, please let me know,

Best Regards,
Emanuel Varga

Telerik WinForms MVP