This topic provides an overview about exporting the WinGrid™ control ’s drop-down list to excel, where any column with a value list will have a drop-down capability in excel containing list of values as in the grid.
The following topics are prerequisites to understanding this topic:
This topic contains the following sections:
Enhancements in exporting data from WinGrid to excel allow exporting the drop-down list. This is similar to the drop-down controls embedded in WinGrid. Any WinGrid column that contains value list such as WinComboEditor or WinDropDown (embedded in WinGrid ) will display a drop-down list for that column in the exported excel worksheet, unless disabled in the WinGridExcelExporter™ .
The following two screenshots illustrate the before (deployed in WinGrid) and the after (imported to Excel).
The WinGrid with drop-down value list before exporting to excel
The Excel worksheet with the drop-down value list after importing from WinGrid
The WinGridExcelExporter component includes the ExportValueList property required for exporting drop-down lists to excel, with its default value – True. You need to change this property to False if you want to prevent exporting the value lists to excel.
The following topic provides additional information related to this topic.