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.
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.
Thanks. This is very helpful.
Any workaround to show GroupByRecord and Summary row to in one row?.
Also I would like to remove the blank row between data and group by row. Is this possible?
I have modified the sample, so now there is now empty rows between the Records and as I said in my previous post you are not able 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.