Hi... i am using xamdatagrid and also i ma using export to excel.it is working fine.But i am using groupby for some fields and color code depending on the perticular field.In xamdatagrid it is working fine but if i export excel group by is coming fine but color is not coming in excel. Plz solve. i am sending image of my xamdatagrid and please send a sample application export to excel with color also.
Hello,
Thank you for your post. I have been looking into it and I created a sample project for you with the functionality you want. Basically I handled the CellExporting event of the ExcelExporter and set the color of the Cell based on the DataRecord’s ParentRecord Value. Please let me know if this helps you or you need further assistance on this matter.
Looking forward for your reply.
Hi stefan its not working.... its showing plain white excel.
You have to modify the logic in the CellExporting eventhandler in order to work with your data. Instead of comparing the GroupByRecord's Value to "Accounting" you should use "PENDING", COMPLETED etc.
Hope this helps you.