Forums Ultimate UI for WPF
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
R
1110
Export to Excel formating
posted

Hi

Attached zip has source and ExportExcel.PNG for expected result.

I am trying to do grid data export to excel. Grid has group by Abbreviation column and ID with sum aggregation.

In Export to excel result, I am looking for

         a. headers to be bold,

         b. Summary rows should be bold and show in individual cells in same row without "Sum" text.

         b. Grand total row should be bold (without Sum text).

Are these possible?. If yes, can you upload the modified code.

Check the ExportExcel.PNG for result that I am expecting.

Thanks in advance.

 

ExportExcel.zip
Parents
No Data
Reply
  • 138253
    Offline posted

    Hello,

     

    I have created a sample project using the code you have provided, where I make the Excel to look the same as in the picture. The only thing that I wasn’t able to do is to put the GroubByRecord and the Summary in one Row, but this is because the GroupByRecord has merged Cells and the summary is on the next row.

     

    Hope this helps you.

    XamDataGridExportFormat.zip
Children