Hi Vishwanathan,
Thank you very much for using the syncfusion products.
That sample has been posted long ago, so we could not able to download it. We have created the new sample for grouping and subtotals. We can group the column or row by the group method available in the range class. The following code snippet also explains the same.
Code snippet(C#):
sheet.Range["B2:J2"].Group(ExcelGroupBy.ByColumns);
sheet.Range["B2:J2"].FormulaArray = "{10,20,30,5,15,35,6,16,36}";
sheet.Range["K2"].Formula = "SUBTOTAL(A2,B2:J2)";
I have also attached the sample for the same along with this update. Please try this sample at your side and let us know if this helps you.
Please let us know if you have any clarifications.
Thanks,
Jawahar.
Sample_a9c461bf.zip