This is a migrated thread and some comments may be shown as answers.

Export to excel problem.

1 Answer 55 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Marcin
Top achievements
Rank 1
Marcin asked on 04 Apr 2011, 07:27 PM
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.

1 Answer, 1 is accepted

Sort by
0
Emanuel Varga
Top achievements
Rank 1
answered on 05 Apr 2011, 09:15 PM
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
Tags
GridView
Asked by
Marcin
Top achievements
Rank 1
Answers by
Emanuel Varga
Top achievements
Rank 1
Share this question
or