Hi, I understand the ultraGridExcelExporter will export the grid as it appears on the screen...
Some columns on my grid use lookup tables (ValueLists), and I would like the export to export the actual value, not the text shown in the grid. Is there any option to make it happen?
Thank you
Hi Tihomir,
Thank you for your reply, but I think you're mistaken or miss understood my question.
When I use the boolean ExportValueLists property, if set to true, it exports and the (display) values on my valuelist to excel, like trying to mimic the dropdown in the grid, if not, it exports only the displayMember values in the column.
In my scenario, I have a list of objects on my ValueList, I display the property Name of my object (DisplayMember) to the user and save (ValueMember)
ie.:
I would like the valuemember to be exported to excel, not the displayMember. Do you know of a way to accomplish this?
Thank you.
Hello Monica,
By default the grid will export the ValueLists. There is an exposed property of the ultraGridExcelExporter - ExportValueLists, which can be used to switch between which value to be exported.
Should you need further help, please let me know.
Sincerely,Tihomir TonevAssociate Software DeveloperInfragistics