How to export SummaryDefinition value to Excel?
Thanks
Hello,
Exporting the summary values is provided built-in for the DataPresenterExcelExporter and you can review it in the Feature Browser under sections “xamDataGrid” / “Excel Exporter” in both “Custom Cell Styling” and “Excel Exporting Events” samples.
Please let me know if you require any further assistance on the matter.
Petar, Thanks very much for the quick response.
The issue is, using DataPresenterExcelExporter, I am not able to apply formula for a cell. Also I need to apply conditional cell formatting based on a cell value. (Eg.. value is > 5, then red color.)
Can you please let me know how to do both using DataPresenterExcelExporter.
I am just checking the progress of this issue and was wondering if you managed to achieve your goal or if you need any further assistance on the matter.
If the above suggestion helped you solve your issue please verify the thread as answered so other users may take better advantage of it.
Hi again,
I have been looking into your latest reply however the XamDataGrid does not support these things built-in, however you can look at this link from our online documentation that shows how this can be achieved manually: http://help.infragistics.com/NetAdvantage/WPF/2010.3/CLR4.0/?page=InfragisticsExcelEngine_Add_a_Formula_to_a_Cell.html . Regarding the XamDataGrid’s conditional formatting it can only be achieved inside the XamDataGrid and not exported to Excel since it depends on WPF elements as described her in this blog post: http://blogs.infragistics.com/blogs/alex_fidanov/archive/2010/01/12/howto-using-wpf-converters-to-style-the-xamdatagrid.aspx
Please let me know if you require any further clarification on this matter.