I followed your article about exporting to Excel.
My question is about exporting the VISIBLE value when I have a ComboBoxPresenter in a Cell. My values are just Guids with no meaning, and I want to export the visible item - the text in the cell.
How can I get this?
Thanks in advance.
Marcos
Hello,
It has been a while since you have made your post, in case you still need support I will be glad to assist you further. I suppose the other community members can benefit from this answer as well. I have been looking into it and since there isn't any built in functioanlity for paging in XamDataGrid, so could you please be more specific how you achieve this.
Feel free to write me if you have further questions.
The CellValuePresenter only works for those rows of the grid that are in the visual tree. What happens if there are multiple pages of data to export?
Hello Marcos,
As the ExcellExporter exports the values of the cells, in your case the GUIDS and not the displaytext you can adjust the exporter little bit to fit your requirements. In the MakeWorkSheetRow function in the XamDataGridExporter class you can check if the CellValuePresenter of the cell is a XamComboEditor and get the display text (instead of the value) and save that into the Excel Cell.
Hope this helps,Alex.